Solved

recovery_model_desc in SQL 2000

Posted on 2010-08-17
5
769 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
ID: 33457377
Its in the status column, me thinks.
0
 
LVL 60

Assisted Solution

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

Author Comment

by:anushahanna
ID: 33457422
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
ID: 33457438
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
ID: 33457489
Thanks.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

914 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

18 Experts available now in Live!

Get 1:1 Help Now