SQL Backup Types - Need Help

[Paul1705]

Hi All,

Newbie here so please go gentle.

I would like to know if I set my SQL backup type to "Log - Backup Transaction Log" Will that actually back up the database (s)

It is currently set to "Full" and I get the following errors:

Database DATABASE NAME is configured to maintain transaction logs.  Transaction log backups are not being performed.  This will result in the log growing to fill all available disk space.  Regular log backups should be scheduled or the database should be changed to the simple recovery mode.

Symantec forum seems to think setting to Log will get rid of that error but will it actually backup the database?

Many Thanks

Paul

[Paul1705]

Oh; this was the article I referred to:

http://www.symantec.com/business/support/index?page=content&id=TECH126063

[ZeRoC00L]

No, you will have to create two jobs, one for the database, and one for the SQL logs.

See the best practices guide:

http://www.symantec.com/business/support/index?page=content&id=HOWTO21793

[Hywel_Mallett]

Yup, you have two options:

1. Do both full backups and transaction log backups.

OR

2. Change your database to Simple Recovery Model. Then you don't need to do transaction log backups.

[ZeRoC00L]

Don't change to simple recovery mode without consulting your DBA !
This may have impact on the recovery possibilities !

[Hywel_Mallett]

Of course you shouldn't make ANY change without researching the possible implications first. There are implications about using the simple recovery model (you can only restore to a full backup), but I would think that if the poster is asking this question, there's a good chance that he's also the DBA! 

[pkh]

Not necessarily.  Some BE users know nothing about SQL.