March 11, 2009 at 8:30 pm
I want to restore all by databases from the network drive one by one and calculate time of restore in a table for each database. steps include
1. restore database from drive
2. record time in a table with db name
3. delete the database
4. restore next database...and so on.
is there any script out there which i can use for this purpose. I know am asking a ready tool from you guys but wud like to request to share any script you guys worked on.
thanks
March 11, 2009 at 9:34 pm
You can put the restore and drop db scripts into individual steps in a job, then the job history will show you how long each step took. The information will be in the system job tables and in msdb..restorehistory, so you may not need to create your own tables. If you delete the db through the GUI, uncheck the box to delete backup & restore history.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply