Full or Simple mode SQL backup

Question

Full or Simple mode SQL backup

stockholm

Default port

Points: 1468
More actions
June 9, 2011 at 2:37 am

#389693

Hi,
I have a couple of question regarding sql 2005/2008 RC backup's mode. New job and new rules here
SQL backup's have 3 mode, Full, Differential and Tlog backup. All db's are in simple mode backup here. My questioin is, why should i use full mode not simple mode, in term of technolog accepts ? advantage or dis-advantage.
Log error:
Date2011-06-08 16:28:09
LogSQL Server (Current - 2011-06-09 01:01:00)
SourceBackup
Message
Database backed up. Database: LAX2, creation date(time): 2010/09/16(09:20:14), pages dumped: 219, first LSN: 156:214:37, last LSN: 156:230:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'Legato#a0e850c8-4e2f-4b4d-b470-4db5ad89f2c6'}). This is an informational message only. No user action is required.
Please, let me know and thnx

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Please read through this - Managing Transaction Logs[/url]

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 2

Kahn

Gail already given the log file management.

Also,read the post which will help you to understand the backups and models advantage and disadvantage.

SQL server Recovery Models and Backup types [/url]

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

stockholm Default port Points: 1468 More actions · Answer 3

Thanks to all.

Special Thanks to Gail Shaw (Gail is best dude)

AlexGreen Right there with Babe Points: 763 More actions · Answer 4

SQL Server has three recovery models:

Simple: This model minimally logs most transactions.

Full: logs all transactions an retains all the transaction log records until after they're backed up.

Bulk-Logged: minimally logs bulk operations, such as index creation, bulk inserts, etc.

How you combine any of these models with full or differential backups will determine how precise your backup could be.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

AlexGreen (6/17/2011)
SQL Server has three recovery models:
Simple: This model minimally logs most transactions.

Simple minimally logs the same operations that bulk-logged minimally logs. The difference is that log records are inactive after a checkpoint, not a log backup

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

mr.jeff.freedman SSC Veteran Points: 235 More actions · Answer 6

I got some help from this post and discussion. Thank you.