August 29, 2005 at 10:07 am
How can I find out what recovery option is set for a database, like
RECOVERY FULL | BULK_LOGGED | SIMPLE
Based, on the setting retrieved, I need to change it to a specific setting using Alter database.
August 29, 2005 at 11:07 am
Just go into enterprise manager and right click the database. Go to properties and on the options tab it will tell you what recovery model is set
August 29, 2005 at 11:11 am
you can also do this in QA...
SELECT DATABASEPROPERTYEX('dbName', 'RECOVERY')
**ASCII stupid question, get a stupid ANSI !!!**
August 29, 2005 at 11:35 am
You can also use
sp_helpdb 'DB_Name'
This will show recovery option in the "status" field, along with all kinds of other info about the database.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply