Automate Restore

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  March 16, 2009 at 6:08 pm

  #202280

  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

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  March 17, 2009 at 3:23 pm

  #961423

  can you try restoring all your databases from an ssis pkg and record the information you need into a table.

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  March 17, 2009 at 4:01 pm

  #961456

  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