Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  'Disk' type Device for Backups

Author  Topic  Jay99 468 Posts Posted - 2001-04-18 : 11:28:52 I have a dev db that I have on the following backup schedule: Full Backup every night WITH INIT to MyDB.bak Trans Backup every hour from 8:00AM to 8:00PM WITH RETAINDAYS = 1 to MyDB.trn My is this. Is it better to do put the full and trans backups into one file rather than have two different devices? Why? Why not? Thanx, Jay