Monday, February 13, 2012

Backup with log truncation

I have a database aaa and i'm taking a full backup daily at 12 Am(I'm overwriting to the existing media) and at the sama time I'm also running the script given below to truncate the transaction logs.

BACKUP LOG [aaa]
WITH TRUNCATE_ONLY

Can i add this script in my full bcak? Please help me in this issue?What's you're recovery model set to?

How are you taking the dump?|||How are you taking the dump?

Brett - This is a little personal - for me I enjoy reading the sports page.

No comments:

Post a Comment