Use of Backup in DTS

#1

Trying to backup a database from DTS using BACKUP, but noticed that each
time I run it increases even when no records added. Assume this is because
the defualt for overwrite is Append to file. Can't see in help text how to
overwrite the old backup.

Any help appreciated.

#2

You have to use the WITH INIT in your BACKUP call. See BACKUP command in SQL
Server Books Online for more information.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/

"Dave Williams" <david_n_williams (AT) lineone (DOT) net> wrote

Trying to backup a database from DTS using BACKUP, but noticed that each
time I run it increases even when no records added. Assume this is because
the defualt for overwrite is Append to file. Can't see in help text how to
overwrite the old backup.

Any help appreciated.

#3

Thanks - words great
"Narayana Vyas Kondreddi" <answer_me (AT) hotmail (DOT) com> wrote

Quote:

You have to use the WITH INIT in your BACKUP call. See BACKUP command in
SQL
Server Books Online for more information.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/

"Dave Williams" <david_n_williams (AT) lineone (DOT) net> wrote in message
news:eOuWLDqhEHA.3264 (AT) tk2msftngp13 (DOT) phx.gbl...
Trying to backup a database from DTS using BACKUP, but noticed that each
time I run it increases even when no records added. Assume this is because
the defualt for overwrite is Append to file. Can't see in help text how to
overwrite the old backup.

Any help appreciated.

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

Use of Backup in DTS

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

Use of Backup in DTS - 08-20-2004 , 05:24 AM

Re: Use of Backup in DTS - 08-20-2004 , 05:34 AM

Re: Use of Backup in DTS - 08-20-2004 , 07:09 AM