September 17, 2008 at 10:27 am
Hi all,
One of my friend got to restore like around 200 databases biweekly.
Is there a way that this restores is automated, or is there a script to restore all this database at once.
Thanks
September 17, 2008 at 10:35 am
This script might help you: http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31995/
Greg
September 17, 2008 at 10:42 am
saw the link but unable to understand, where to put the bak file location.
September 17, 2008 at 1:10 pm
ALIF (9/17/2008)
saw the link but unable to understand, where to put the bak file location.
You should use @path variable for that.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply