October 26, 2012 at 8:11 pm
Hi All,
I have to take backups of 100+ databases from one server and restore it to another server.
I have done the backups using a job and it went pretty smoothly.
Now, my question is can I do the restore all these DBs using a job as well.
I have done restore using jobs before but this volume.
Does anyone have a good script for this type of restore or any advise or suggestions would be much appreciated.
Thanks,
SueTons.
Regards,
SQLisAwe5oMe.
October 27, 2012 at 12:11 am
Try this
http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30962/
-----------------------------------------------------------------------------
संकेत कोकणे
March 20, 2013 at 12:37 pm
I am successfully using the script to restore several databases. I have one product that creates their databases using a naming convention of 123_databasename which causes errors when trying to restore using the sp. I have tried various modifications to the stored procedure to have it restore using the exact db name to no avail.
Anyone have any ideas?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply