PowerShell script exchange
Post Reply
Curry
Lurker
Posts: 2
Liked: never
Joined: Oct 19, 2015 7:14 am
Contact:

Automated export of SQL Server mdf-File

Post by Curry »

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
veremin
Product Manager
Posts: 20282
Liked: 2257 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Automated export of SQL Server mdf-File

Post by veremin »

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.
Curry
Lurker
Posts: 2
Liked: never
Joined: Oct 19, 2015 7:14 am
Contact:

Re: Automated export of SQL Server mdf-File

Post by Curry »

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

Greetings Tobias
veremin
Product Manager
Posts: 20282
Liked: 2257 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Automated export of SQL Server mdf-File

Post by veremin »

You're welcome. Feel free to ask, should other questions arise. Thanks.
Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests