Backup Exec Full DB Backup
Ed,
I'd have expected the SQL Agent to have this option anyway - but if it doesn't
then truncate the log before running the dump.
Quote:
> I am putting together a backup plan for a SQL Server 6.5 DB on NT 4.0 server
> using Seagate Backup w/Exec Sql Option 7.2. Being that my DB is only 2 GB, I
> am planning on doing a full backup each night. What I would like to know is
> how to reliably trucnate the transaction log at the same time. Can I use the
> "run before/runa after " feature. Any help would be appreciated.
Neil Pike MVP/MCSE. Protech Computing Ltd
(Please post ALL replies to the newsgroup only unless indicated otherwise)
For SQL FAQ entries see www.ntfaq.com/sql.html
and http://www.***.com/
and GO MSSQL lib 1 on Compuserve
