Database recovery mode - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Database recovery mode

Author

Topic

Hippi
Yak Posting Veteran

63 Posts

Posted - 2005-06-28 : 16:14:58

Hey folks,

Do you guys know how to get database recovery mode (Full, Simple, etc)
using T-SQL?

Thanks,
Hippi.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-06-28 : 16:33:57

Check out DATABASEPROPERTY

here is the BOL entry on it http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_9aih.asp

-ec

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2005-06-28 : 20:04:40

See also: ALTER DATABASE. BOL has great powers....

HTH

=================================================================
'Tis with our judgements as our watches: none Go just alike, yet each believes his own. -Alexander Pope, poet (1688-1744)

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2005-06-29 : 10:36:20

You can also use sp_helpdb 'dbname'. You have to look for it, though. It is in a list of property-value pairs.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources