Progress of restore T-SQL

• Jules Bonnot

  SSCertifiable

  Points: 5488

  More actions

  June 18, 2007 at 3:55 am

  #75156

  When a restore is done using the interface it displays a progress percentage in 2005 or blue blobs in 2000.

   

  I have restarted managment studio and now cant see the progress. This is an enormous DB and i need to see how the restore is progressing is there a way i can retrieve this information using T-SQL.

   

  Thanks for any help.

  Jules

  www.sql-library.com[/url]

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  June 19, 2007 at 10:55 am

  #713903

  from BOL:

  RESTORE DATABASE { database_name | @database_name_var }

  [ FROM < backup_device > [ ,...n ] ]

  [ WITH

      [ RESTRICTED_USER ]

      [ [ , ] FILE = { file_number | @file_number } ]

      [ [ , ] PASSWORD = { password | @password_variable } ]

      [ [ , ] MEDIANAME = { media_name | @media_name_variable } ]

      [ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]

      [ [ , ] MOVE 'logical_file_name' TO 'operating_system_file_name' ]

              [ ,...n ]

      [ [ , ] KEEP_REPLICATION ]

      [ [ , ] { NORECOVERY | RECOVERY | STANDBY = undo_file_name } ]

      [ [ , ] { NOREWIND | REWIND } ]

      [ [ , ] { NOUNLOAD | UNLOAD } ]

      [ [ , ] REPLACE ]

      [ [ , ] RESTART ]

      [ [ , ] STATS [ = percentage ] ]

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."