Solved

recovery_model_desc in SQL 2000

Posted on 2010-08-17
5
768 Views
Last Modified: 2012-08-14
sys.databases has recovery_model_desc. where is that column in SQL 2000? I could not see it in sysdatabases.

thanks
0
Comment
Question by:anushahanna
  • 3
  • 2
5 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
Comment Utility
Its in the status column, me thinks.
0
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 500 total points
Comment Utility
select name, databasepropertyex(name, 'Recovery') as RecoveryModel from master.dbo.sysdatabases order by name
0
 
LVL 6

Author Comment

by:anushahanna
Comment Utility
that's it.

is there a reason there is not documentation (that i could find) on sysdatabases.status as you thought so.
0
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 500 total points
Comment Utility
its a bit, so it has to be parsed that way.  

http://msdn.microsoft.com/en-us/library/aa260406%28SQL.80%29.aspx
0
 
LVL 6

Author Comment

by:anushahanna
Comment Utility
Thanks.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now