-
- Veeam ProPartner
- Posts: 45
- Liked: never
- Joined: Feb 16, 2011 9:10 am
- Full Name: David Molina
- Location: Valencia, Spain
- Contact:
SAP restore
Hello,
This is a new handicap for me as Veeam user. On a new customer I have several servers with SAP and SQL Server DB. Actually, we are doing backup with Veeam, but my main issue is: how should I restore SAP DB? By SAP conditions, DB should be restored fully. What options do I have? I have installed my first Veeam Backup Enterprise Edition.
If I use SQL AIR, I can't because customer has installed SAP with local user, and Veeam AIR runs with domain users. At this point, when AIR tries to connect to restored VM, it can't because Veeam user hasn't permissions to do it (only local user), and I can't change the user to authenticate through wizard. I searched on Internet, and it seems to be a restriction of SQL Server (SQL Server Management Studio can't connect either).
Other option could be to restore DB file on original location. Could this option work? I'm not a SQL Server expert.
Regards,
This is a new handicap for me as Veeam user. On a new customer I have several servers with SAP and SQL Server DB. Actually, we are doing backup with Veeam, but my main issue is: how should I restore SAP DB? By SAP conditions, DB should be restored fully. What options do I have? I have installed my first Veeam Backup Enterprise Edition.
If I use SQL AIR, I can't because customer has installed SAP with local user, and Veeam AIR runs with domain users. At this point, when AIR tries to connect to restored VM, it can't because Veeam user hasn't permissions to do it (only local user), and I can't change the user to authenticate through wizard. I searched on Internet, and it seems to be a restriction of SQL Server (SQL Server Management Studio can't connect either).
Other option could be to restore DB file on original location. Could this option work? I'm not a SQL Server expert.
Regards,
-
- VP, Product Management
- Posts: 6029
- Liked: 2856 times
- Joined: Jun 05, 2009 12:57 pm
- Full Name: Tom Sightler
- Contact:
Re: SAP restore
Veeam AIR is primarily useful for restoring individual tables/rows, it's not typically required or reocmmended for a full database restore.
The most common option for a full restore of a SQL database is to simply stop the SQL service (or dismount the database being restored) and perform a file-level restore of the SQL databases files. It's pretty easy. Other options would be to simply restore the entire VM (which would obviously include the database files) or just the virtual disks that contain the database files assuming that you are looking to perform a full restore of all SQL databases on the system.
The most common option for a full restore of a SQL database is to simply stop the SQL service (or dismount the database being restored) and perform a file-level restore of the SQL databases files. It's pretty easy. Other options would be to simply restore the entire VM (which would obviously include the database files) or just the virtual disks that contain the database files assuming that you are looking to perform a full restore of all SQL databases on the system.
-
- Veeam ProPartner
- Posts: 45
- Liked: never
- Joined: Feb 16, 2011 9:10 am
- Full Name: David Molina
- Location: Valencia, Spain
- Contact:
Re: SAP restore
Hi Tom,
For a full restore it's correct this way. I'll implement it for our customers, because several of them work with SAP
But for some which ones use SQL Server as common database, what should I do if I can't connect to database due it only uses local users of DB machine? Should I give DB admin permissions to Veeam user? Or is there any possibility of specify which Windows user connects to database?
Regards,
For a full restore it's correct this way. I'll implement it for our customers, because several of them work with SAP
But for some which ones use SQL Server as common database, what should I do if I can't connect to database due it only uses local users of DB machine? Should I give DB admin permissions to Veeam user? Or is there any possibility of specify which Windows user connects to database?
Regards,
-
- Veeam Software
- Posts: 21133
- Liked: 2140 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: SAP restore
You do not need to connect to database to be able to restore its files directly to the original location. You can restore them via the Veeam Backup Enterprise Manager web UI.
-
- Veeam ProPartner
- Posts: 45
- Liked: never
- Joined: Feb 16, 2011 9:10 am
- Full Name: David Molina
- Location: Valencia, Spain
- Contact:
Re: SAP restore
That's right foggy, and finally I'm going to left this option.
By the way, changing a little the topic, why can't SQL AIR login remotely on DB with another user different to whom Veeam was started? Basically, if I start Veeam with user A, why can't I use "user B" to login on remote DB through SQL AIR? Is it a SQL Server restriction? I've searched on web, and that's what it seems.
Regards,
By the way, changing a little the topic, why can't SQL AIR login remotely on DB with another user different to whom Veeam was started? Basically, if I start Veeam with user A, why can't I use "user B" to login on remote DB through SQL AIR? Is it a SQL Server restriction? I've searched on web, and that's what it seems.
Regards,
-
- Veeam Software
- Posts: 21133
- Liked: 2140 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: SAP restore
David, I've just checked the wizard, actually, while submitting the lab request, you have the ability to select the type of authentication to use – Windows or SQL authentication.
-
- Veeam ProPartner
- Posts: 45
- Liked: never
- Joined: Feb 16, 2011 9:10 am
- Full Name: David Molina
- Location: Valencia, Spain
- Contact:
Re: SAP restore
Yes, that's true, but for Windows authentication it isn't possible to choose another user. It's only possible for SQL authentication.
-
- VP, Product Management
- Posts: 7052
- Liked: 1498 times
- Joined: May 04, 2011 8:36 am
- Full Name: Andreas Neufert
- Location: Germany
- Contact:
Re: SAP restore
Hi ... I had this problem too, because my customer uses multible domains and standallone sql servers. For me it was the best way of adding sql authentication to the server and use the sa user for restore things.
-
- Veeam ProPartner
- Posts: 45
- Liked: never
- Joined: Feb 16, 2011 9:10 am
- Full Name: David Molina
- Location: Valencia, Spain
- Contact:
Re: SAP restore
Thanks Andreas. I think I'll choose this way.
Who is online
Users browsing this forum: AdsBot [Google], Baidu [Spider], Bing [Bot], karsten123 and 2 guests