Comprehensive data protection for all workloads
Post Reply
GStarF
Lurker
Posts: 1
Liked: never
Joined: Jun 18, 2018 1:14 pm
Full Name: Gwendolyn Foster
Contact:

Veeam SQL Server Backup and Restore

Post by GStarF »

Can the Veeam SQL Server database Backup and Restore be managed separately from the Veeam VM backups/snapshots? Is the Veeam Explorer for SQL Server used to manage SQL Server database backups and restores or can they be managed without this? Can a SQL Server database backup be scheduled without scheduling a VM backup/snapshot?
veremin
Product Manager
Posts: 20283
Liked: 2258 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Veeam SQL Server Backup and Restore

Post by veremin »

No, you cannot perform SQL transaction log backup without backing up SQL VM. Thanks.
jbader
Novice
Posts: 7
Liked: 1 time
Joined: May 22, 2018 4:08 pm
Full Name: John Bader
Contact:

Re: Veeam SQL Server Backup and Restore

Post by jbader »

Is there a way to schedule an automated SQL db restore from a production server to a dev server?
Dima P.
Product Manager
Posts: 14415
Liked: 1576 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Veeam SQL Server Backup and Restore

Post by Dima P. »

Hello John,

There is no way to do that in the UI. From the top of my head PowerShell script can be used to automate the recovery. Here is a link to PowerShell guide: SQL item restore cmdlets. Cheers!
jbader
Novice
Posts: 7
Liked: 1 time
Joined: May 22, 2018 4:08 pm
Full Name: John Bader
Contact:

Re: Veeam SQL Server Backup and Restore

Post by jbader »

Thanks. I've used this method. However, support will not assist when there are issues. Will this functionality be added in a future update or release?
veremin
Product Manager
Posts: 20283
Liked: 2258 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Veeam SQL Server Backup and Restore

Post by veremin »

Currently we don't have this feature scheduled for future product update or release. Though, feel free to leverage the existing script. Thanks.
Post Reply

Who is online

Users browsing this forum: Google [Bot] and 151 guests