Showing posts with label recovery. Show all posts
Showing posts with label recovery. Show all posts

Monday, March 12, 2012

How to find out the current recovery mode for a given database

Never mind, I found it from an old post:
SELECT DATABASEPROPERTYEX('Mydb', 'Recovery')
"Zen" <zen@.nononospam.com> wrote in message
news:u%236G$sllGHA.3588@.TK2MSFTNGP02.phx.gbl...
> Hi,
> Would you know how I can find out if my database is set with full or
> simple recovery mode? Thanks!
>Hi,
Would you know how I can find out if my database is set with full or simple
recovery mode? Thanks!|||Never mind, I found it from an old post:
SELECT DATABASEPROPERTYEX('Mydb', 'Recovery')
"Zen" <zen@.nononospam.com> wrote in message
news:u%236G$sllGHA.3588@.TK2MSFTNGP02.phx.gbl...
> Hi,
> Would you know how I can find out if my database is set with full or
> simple recovery mode? Thanks!
>

How to find out the current recovery mode for a given database

Hi,
Would you know how I can find out if my database is set with full or simple
recovery mode? Thanks!Never mind, I found it from an old post:
SELECT DATABASEPROPERTYEX('Mydb', 'Recovery')
"Zen" <zen@.nononospam.com> wrote in message
news:u%236G$sllGHA.3588@.TK2MSFTNGP02.phx.gbl...
> Hi,
> Would you know how I can find out if my database is set with full or
> simple recovery mode? Thanks!
>