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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy