asked on

Backup Exec 11d SQL 2000 Backup Question - Transaction Logs

I have a question about backups on a Microsoft SQL 2000 server.

We are using Backup Exec 11d's SQL backup.

I have the full backup option selected but it doesn't appear to truncate the logs. I found that this is a problem because most of the space on the drive has been used (shame on me for not catching this earlier I know.)

Do I need to run a separate log backup job to backup and truncate the transaction logs?

Thanks - Spyder

twoboats

Full db backup doesn't truncate tlog. You need to do a tlog backup to remove the active portion of the log. Once there's space free in the log file, you need to shrink it (dbcc shrinkfile) if you need to recover some \ all of the allocated space

spyder357

ASKER

So if I understand right....

1) A separate log backup job needs to be run in addition to the full backup.

2) I need to manually shrink the size of the log file by running dbcc shrinkfile

One more question.....

When I create this new job to backup the transaction log....would there be any problems running a post backup command to shrink the DB or does that need to remain a manual process?

(Although I'm not even sure if you could script a SQL command in BE)

ASKER CERTIFIED SOLUTION

twoboats

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

spyder357

ASKER

Thank you very much.

twoboats

You're welcome.