Recovery Model, Transaction Log, Novice Sites

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

SQL Server 2005 Forums

SQL Server Administration (2005)

Recovery Model, Transaction Log, Novice Sites

Author

Topic

desmallbiz
Starting Member

2 Posts

Posted - 2009-08-06 : 22:11:12

With the popularity of SQL Server Express on the rise, I am finding many sites unable to manage their transaction logs on their own.

Is their a consensus opinion for using the Simple Recovery model at less sophisticated sites, some most likely running Express.

thanks in advance

jholovacs
Posting Yak Master

163 Posts

Posted - 2009-08-07 : 10:32:34

Consensus? I don't think you'll find that with a general version-to-recovery model statement. The recovery model should reflect the business needs for recoverability and resource utilization; generally speaking however, if you are using SQL Express, your data is small enough and manageable enough that the Simple recovery mode would be adequate in most situations... if your data is business-critical to the point that it requires point-in-time recoverability, chances are that you have outgrown SQL Server Express edition already.

...but that's just my opinion. I expect others will disagree.

SELECT TOP 1
w.[name]
FROM
dbo.women w
INNER JOIN
dbo.inlaws i
ON
i.inlaw_id = w.parent_id
WHERE
i.net_worth > 10000000
AND
i.status IN ('dead', 'dying')
AND
w.husband_id IS NULL
ORDER BY
w.hotness_factor DESC

desmallbiz
Starting Member

2 Posts

Posted - 2009-08-07 : 15:41:42

Yes, lot's of room for subjectivity but without the tools to manage automated frequent transaction log backups one would think a simple recovery model would be most appropriate.

Most firms using SQL Express don't have a DBA or for many an IT staff. I'm not sure how they can hope to manage a log file.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-08-07 : 16:47:04

This question must always be answered with the following question:

"How much data/work are you willing to lose?"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources