Re: How to save a backup job as "overwrite existing media"

#1

Magnus Österberg wrote:

Quote:

This is what I would like to accomplish:

But when I click OK to save my backup job, and then re-opens it, it
looks like this:

My settings are gone! What do I do wrong?

I run SQL Server 2000 sp#4 on windows 2000 sp#3.

/Magnus

This is not a backup job, and neither is it saved. This is an
interactive dialog to execute a backup process immediately you click OK.
Some "defaults" have been saved, but for repeat execution, use a T-SQL
script in a job or create a Maintenance Plan. There is no way to set the
default options to include overwrite.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: How to save a backup job as "overwrite existing media"

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: How to save a backup job as "overwrite existing media" - 10-18-2005 , 03:03 PM