Video Screencast Help

Configuration SQL recommend

Created: 28 Oct 2012 | 5 comments

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?

Discussion Filed Under:

Comments 5 CommentsJump to latest comment

Backup_Exec's picture

Hi

Please check link below

http://www.symantec.com/docs/TECH126063

Hope that helps

Thanks

Sameer

Don't forget to give a "Thumbs Up" or Mark as "Solution" if someones advice has helped you.

_THOR_'s picture

Hi,

What is the difference between a simple configuration or complete?

pkh's picture

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.

_THOR_'s picture

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?

pkh's picture

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.