In SQL 2000 how can you script a differential backup to backup to a
particular named file and to replace the existing file contents?Here's an example:
BACKUP DATABASE pubs TO DISK='G:\Pubs.BAK' WITH INIT, DIFFERENTIAL
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
<robin9876@.hotmail.com> wrote in message
news:1122993046.668119.116470@.o13g2000cwo.googlegroups.com...
In SQL 2000 how can you script a differential backup to backup to a
particular named file and to replace the existing file contents?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment