SQL command for database recovery

1145605 pts.
Tags:
Database
SQL Server
Does anyone know if there's any SQL command that can determine the recovery model of my SQL Server database? I'm trying to figure out if the database is in full recovery. Thank you very much.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.
The following will get it from SQL.  There is a way with Visual
Studio too, but I am not sure how.

SELECT name, recovery_model_desc    FROM sys.databases       WHERE name = 'model' ; GO

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • geemamoore

    RESTORE DATABASE YourDB
    FROM DISK = 'D:\BackUpYourBaackUpFile.bak'
    WITH MOVE 'YourMDFLogicalName' TO 'D:\DataYourMDFFile.mdf',
    MOVE 'YourLDFLogicalName' TO 'D:\DataYourLDFFile.ldf'

    365 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: