Posted by Matik on 02/16/06 12:13

Hello,


I've follow problem - thing to consider.

SQLServer 200 sp3a, ms win 2003 server
db simple recovery

There is a production database, wich is around 20gb big. Db is backed
up each day completely, but it takes up to 30 minutes.
Because there is a simple recovery model, there is no transaction log
backup (it fails anyway), and we do not have up-to-point recovery.

I'm considering to switch to full recovery model, but ....
The problem is, I do not want to affect performance (when the backup is
running, database is hardly avalible).

So my question will be: does the full recovery model, will be better
for db performance (for acces and blocking db; means, does it will take
shorter?)
Strategy will be (I hope ok) to back up during the week only
transaction log (incremental), and once at the weekend, full database
backup.

Generaly, which one is better for performance?
Which strategy will be the best, to keep performance at high level, but
also have the possibility to restore data (in case of emergency) from
the newest possible backup.

Thanks for help

Matik

• Next in forum: Torn page problem
• Prev in forum: torn page detection and auto shrink: performance?
• Thread view: Recovery model problem; db properities

[Reply to this message]