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!
>
Showing posts with label mydb. Show all posts
Showing posts with label mydb. Show all posts
Monday, March 12, 2012
Subscribe to:
Posts (Atom)