question

logicinside22 avatar image
logicinside22 asked

Automate Restore from production to Dev

HI Everyone , I am looking for steps or script to automate restore from production env to dev. 1) Production Db backup are taken from Maintenance plan with date time stamp on .bak file (DBa_Support_backup_2015_02_11_003012_8079705.bak). 2) looking for script which automatically grab the most current backup file from network or local drive and restore it. Thank You
restorebackup-restore
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered
I'm sure I've answered something similar to this before... Oh yes. https://thelonedba.wordpress.com/2013/01/24/bulk-restores-response-to-a-question-on-ask-sqlservercentral/ If you only want the most recent FULL backup, then you can stop reading when I start talking about DIFFs.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

logicinside22 avatar image logicinside22 commented ·
Thanks Thomas
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.