10-28-2012 03:10 AM
Hi,
I am having the warning V-79-40960-37914 with Symantec Backup 2010 R3.
The DB in SQL 2008 R2 is set to Full, and the Symantec Backup is also full.
What is the difference between a simple setup and a full, in case that the SQL fails, that type of setup would you recommend?
10-28-2012 03:21 AM
10-28-2012 03:28 AM
Hi,
What is the difference between a simple configuration or complete?
10-28-2012 07:49 AM
When you set your SQL recovery mode to simple, then SQL does not maintian transaction logs and it would not be able to do point-in-time restores. (If you are not familiar with point-in-time restores, search the Internet for a full explanation.) Some SQL applications requires full recovery mode, so you should check with your SQL administrator before you switch the database to simple recovery mode.
When the database is in full recovery mode, you would need to clear your transaction log by running a BE log backup. Otherwise, it will grow and use up all your disk space.
10-28-2012 07:57 AM
Then the warning from Symantec, to which relates?.
If I make a simple backup, backup and i only by the night, could only restore the previous day, never if for example i fails at 12.00h in the morning, no?
10-28-2012 08:50 AM
The warning is when your database is maintaining logs and the logs are not being cleared by running a log backup. If you don´t need to do point-in-time restores, then you can switch your databases to simple recovery mode, i.e. they don't maintain logs and the warning will disappear. However, as I said before, some SQL application requires transaction logs so you should check with your SQL administrator before switching the database to simple recovery mode.