We are in the early (development test) stages of upgrading from SQL200
to SQL2005. We have noticed that our backups, created with the append
option, are not stored as individual .bak files when viewed through
Windows Explorer. From time to time, we have to create disk space by
deleting backup files. How is this managed in SQL2005?

(barbara.plume@otda.state.ny.us) writes:
> We are in the early (development test) stages of upgrading from SQL200
> to SQL2005. We have noticed that our backups, created with the append
> option, are not stored as individual .bak files when viewed through
> Windows Explorer. From time to time, we have to create disk space by
> deleting backup files. How is this managed in SQL2005?

It appears that you are looking into maintenance plans. I seem to recall
that there is an option to select separate files.

Beware that if you use maintenance plans, that you should not use SQL 2005
SP2 as is, as there are some serious bugs with maintenance plans in
SP2. There is a cumultative update you need to get.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx