Automated export of SQL Server mdf-File

PowerShell script exchange

Automated export of SQL Server mdf-File

Veeam Logoby Curry » Mon Oct 19, 2015 7:31 am

Hello!

We are doing our SQL Server database backups with VEEAM.

Now we have a requirement from multiple on-premises clients to provide them with a full-backup of one particular database on a weekly basis.
In VEEAM B&R there is a button to export an mdf-File for a specific SQL Server database.

I would now like to know if there is a way of automating this export task (preferably PowerShell).

Thank you in advance.

Greetings Tobias
Curry
Lurker
 
Posts: 2
Liked: never
Joined: Mon Oct 19, 2015 7:14 am

Re: Automated export of SQL Server mdf-File

Veeam Logoby v.Eremin » Mon Oct 19, 2015 8:45 am

If I got it correctly, you can initiate Windows FLR for a specific restore point, and once the session is started, copy .mdf file to whatever location you want to. Thanks.
v.Eremin
Veeam Software
 
Posts: 13251
Liked: 965 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Automated export of SQL Server mdf-File

Veeam Logoby Curry » Mon Oct 26, 2015 1:45 pm

You helped me a lot, thank you!
The link you posted initially drove me in the right direction.

Greetings Tobias
Curry
Lurker
 
Posts: 2
Liked: never
Joined: Mon Oct 19, 2015 7:14 am

Re: Automated export of SQL Server mdf-File

Veeam Logoby v.Eremin » Tue Nov 03, 2015 4:52 pm

You're welcome. Feel free to ask, should other questions arise. Thanks.
v.Eremin
Veeam Software
 
Posts: 13251
Liked: 965 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin


Return to PowerShell



Who is online

Users browsing this forum: No registered users and 5 guests