Back up problem

[petertickler]

My back-up (using Veritas' Backup Exec) is tending to fail to back up some of the databases.

I am getting the message:

"Unable to open the item <dbname>?primary - skipped"

This is followed by "BACKUP LOG is not allowed while the trunc. log on chkpt. option is enabled. Use BACKUP DATABASE or disable the option using sp_dbpotion."

What are the implications of disabling this trunc. log on chkpt. option???

Peter Tickler

 

[nigelrivett]

See

http://www.nigelrivett.net/TransactionLogFileGrows_1.html

It is talking about the recovery model which you have as simple.
Usually this is the best option unless you really need log backups. You need to set veritas to only do full and diff backups. Or better schedule the backups yourself using t-sql and the copy the backup files.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.