Databeses with simple recovery will be excluded

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

General SQL Server Forums

New to SQL Server Administration

Databeses with simple recovery will be excluded

Author

Topic

carrlos
Starting Member

8 Posts

Posted - 2012-05-24 : 04:32:42

Hi,
The warning: Databeses with simple recovery will be excluded! is showed when I want to define back up transaction log task
What could be the reason?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-05-24 : 04:36:45

because it is not applicable for Simple Recovery model

refer to BOL on Recovery Model for further details

KH
[spoiler]Time is always against us[/spoiler]

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2012-05-24 : 04:39:29

Its a simple information message. If you have any databases in Simple recovery mode, then you will never have transaction logs for these that you can back up. Read up on recovery models in SQL.

Her is a simple explanation: http://databases.about.com/od/sqlserver/a/recoverymodels.htm

and here is the BOL version: http://msdn.microsoft.com/en-us/library/ms189275.aspx

carrlos
Starting Member

8 Posts

Posted - 2012-05-24 : 04:51:00

Thanks in advance

carrlos

carrlos
Starting Member

8 Posts

Posted - 2012-05-24 : 05:06:19

So, Is it possible to switch from simple to full recovery without any sql server applications truble?

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2012-05-24 : 10:01:51

This is a very good article on transaction log management.

Managing Transaction Logs
http://www.sqlservercentral.com/articles/Administration/64582/

CODO ERGO SUM

prett
Posting Yak Master

212 Posts

Posted - 2012-05-25 : 06:46:14

quote:
Originally posted by carrlos

So, Is it possible to switch from simple to full recovery without any sql server applications truble?

You can easily switch from simple to full recovery model by using following query:

USE master;
ALTER DATABASE model SET RECOVERY FULL;

But you have to consider some points before & after switching to another recovery model. Check this article, it has good explanation: http://www.data-base-recovery.blogspot.in/2012/05/important-points-when-switch-from-one.html

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources