Is the database fully recovered

[brage98]

Is there a view or a property of Microsoft.SqlServer.Management.Smo that'll tell me if a database is already fully recovered?

I'm running a command in powershell to put my database back in recovery mode... however if the database is already fully recovered I get the "The database is already fully recovered" exception...

So what I want is:

if (NOT Database_Is_Already_Recovered)
{
  RESTORE DATABASE $targetDBName WITH RECOVERY
}

Your help on determining Database_Is_Already_Recovered is much appreciated

 

[SQLBill]

Try this (untested):

IF (SELECT state FROM sys.databases WHERE [name] = mydatabase) <> 0
  BEGIN
    RESTORE DATABASE $targetDBName WITH RECOVERY
  END

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[brage98]

Great thanks!