Backup Exec Full DB Backup 
Author Message
 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


Sun, 15 Jul 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Question about Transaction log backup with Backup Exec

2. SQL 7.0 Backup and Backup Exec

3. SQL Server backup utility vs Seagate Backup Exec

4. Backup of SQL 2K with Backup Exec 8.6 SQL agent

5. Problems backup up SQL Server 7.0 with Backup Exec

6. NT Backup vs Backup Exec

7. Nightly Backup Question (Backup Exec vs. Dump)

8. Backup Exec 7.3 will not backup

9. Backup of database tables through Seagate Backup Exec 7.2 SQLserver agent

10. Backup and Disaster Recovery Plans and Backup Exec

11. Problem with Full backup and Differential backup reference

12. Differential backups larger than full backups?


 
Powered by phpBB® Forum Software