check db if in restore

• Glitch

  Right there with Babe

  Points: 752

  More actions

  February 3, 2005 at 6:13 am

  #66874

  Hi,

  I need to query the back up database, but when the backup is in restore i can't query it. Is their a way to check if the database is in restore. Basically, a store procedure run every 5 mins, if the database is in restore, I want the procedure to quit it self and run again in 5 mins.

   

  thanks

   

• kozloski

  SSC Eights!

  Points: 804

  More actions

  February 4, 2005 at 8:26 am

  #540690

  Glitch,

  You should look into the DATABASEPROPERTY function in BOL.

  SELECT DATABASERPROPERTY('dbname', 'IsInLoad')

  will return 1 if it is being restored, 0 otherwise.

  -- J.Kozloski, MCDBA, MCITP