Solved

recovery mode of database at last service startup

Posted on 2011-09-16
4
307 Views
Last Modified: 2012-05-12
is the info of what the databases has as recovery mode when the services last started up, stored anywhere in system tables for us to see?
0
Comment
Question by:25112
4 Comments
 
LVL 21

Expert Comment

by:JestersGrind
Comment Utility
The are a number of ways to see what the current recovery model is.  I don't know of any to see what the recovery model used to be.  Why do you need to know that?  It's only 1 of 3 options.

Greg

0
 
LVL 25

Accepted Solution

by:
jogos earned 250 total points
Comment Utility
Don't think it is stored at startup. But the backup-history can tell you when wich backup is taken. Compare that with other databases and you can see when it's changed.

To see info about all databases including recovery model

exec sp_helpdb


To see it for one db
 
exec sp_helpdb 'testdb'
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 250 total points
Comment Utility
Any change to the Recovery Model is saved in the SQL Server Error Log.

The entry will look something like this:

Message
Setting database option RECOVERY to SIMPLE for database YourDatabaseName.
0
 
LVL 5

Author Comment

by:25112
Comment Utility
Greg, it is to find out when and who changed the recovery model..

both jogos method (from backup) and acperkins method works good.. thanks!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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 …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
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.

762 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

10 Experts available now in Live!

Get 1:1 Help Now