Posted by Erland Sommarskog on 10/04/07 22:05

(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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: time conversion hiccup
• Prev in forum: Re: Retrieve next lowest number in mixed set
• Thread view: Re: SQL2005 database backup files

[Reply to this message]