March 16, 2009 at 6:08 pm
How can i automate my DB restore if i have litespeed. I dont see much features from litespeed except that backup and restores are fast. Actually i am trying to test my backup files of all databases in a server by restoring and also keep track of mdf file size,ldf file size,number of tables, database bkpdate,restore date and any other possible information into a table.
I am sure this can be done by not sure how to automate this for all the databases in a server. PLease help me with the scripts if you are already using.
Thanks
March 17, 2009 at 3:23 pm
can you try restoring all your databases from an ssis pkg and record the information you need into a table.
March 17, 2009 at 4:01 pm
Make use of stored procs. like EXEC master.dbo.xp_backup_database and EXEC master.dbo.xp_restore_database as listed at -->http://vyaskn.tripod.com/backup_and_restore_with_sql_litespeed.htm
MJ
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply