Unity - SQL - Simple / Full Recovery Methods

Unanswered Question
May 2nd, 2007

Hi

I've come accross a few problems with Unity servers where the SQL transaction log for the UnityDB grows until it fills the disk and starts causing problems (i.e. 7gb+).

As I have some background in SQL it's easy enough to fix... but I've seen this post:

http://forum.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Unified%20Communications%20and%20Video&topic=Unified%20Communications%20Applications&CommCmd=MB%3Fcmd%3Ddisplay_location%26location%3D.1dd6aa63

It states we need Full recovery model, or the 'nightly truncates' will fail. If they do fail, surely this can be ignored as truncations are not required with the Simple recover model?

Anyone any other reason full recovery would be required? The difference AFAIK is that with simple, the transaction log is cycled and therefore kept small.

With full, it is written to, and can grow, and the log is only truncated/reused after a full backup.

If, therefore, our customers don't back up their DB regularly (and we all know they don't!) they get this problem... eventually it grows.

Why would full recovery be required when even if we did a full system restore we wouldn't likely do a transaction log restore, as we have a full DB backup taken at the point the whole system was backed up?

Thanks

Aaron

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
neesharm Thu, 05/03/2007 - 01:28

Aaron This is not an answer to your question However you might want to look at following Bug

http://www.cisco.com/cgi-bin/Support/Bugtool/onebug.pl?bugid=CSCeh01218

Also a Microsoft document that answers exactly that question as to why it grew so large. Again, this document applies to any applications that uses MS SQL as its backend database.

http://support.microsoft.com/kb/62866

Here is the comprehensive doc about SQL server maintenance.

http://support.microsoft.com/default.aspx?scid=kb;en-us;873235

Actions

This Discussion