recovery mode

Asked By

20-Nov-09 10:33 AM

Reply

Hi, my database is simple recorvery model now, what is the good/bad things if I swith to full? thanks...

Whatever answers you get here are no substitute for the detailed descriptionin

Linchi Shea replied to

20-Nov-09 11:20 AM

Reply

Whatever answers you get here are no substitute for the detailed description in the Books Online on this subject. I suggest you take a read there. That said, with the full recovery mode, the most significant advantage is that you can recover to a point in time if you back up your transaction log regularly and preserve the log backups properly. I guess the bad thing is that you need to manage your log backups. Otherwise, you can blow up your transaction log easily. Linchi

If you do not manage your transaction logs, they will fill up your hard

Jay replied to

20-Nov-09 11:46 AM

Reply

If you do not manage your transaction logs, they will fill up your hard drive and bring the database server down.

Thanks Linchi,If I siwth to full recovery, will slow down the production a bit?

20-Nov-09 11:53 AM

Reply

Thanks Linchi, If I siwth to full recovery, will slow down the production a bit? description log things if

No. You will be required to do more maintenance though.

Jay replied to

20-Nov-09 11:58 AM

Reply

No. You will be required to do more maintenance though.

(someone@js.com) writes:Wrong question.

Erland Sommarskog replied to

20-Nov-09 07:12 PM

Reply

(someone@js.com) writes: Wrong question. The right question is: if the database goes belly-up how much can you afford to lose? Is it OK to restore the most recent backups (you are taking backups, are not you?), or are you content with losing recent updates? And this is not meant to be a rhethoric question, but a real one that you need to ask yourself. Full recovery will help you reduce data-loss in case of a disaster. But it comes with a cost, as it incurs more management. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Thanks Jay,If I swith to Full, can I still have one bak file or the log files

01-Dec-09 01:16 PM

Reply

Thanks Jay, If I swith to Full, can I still have one bak file or the log files are separate?

Previous Discussion: QA - edit procedure shows "create"