Solved

recovery_model_desc in SQL 2000

Posted on 2010-08-17
5
777 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

730 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