Differential Backup Script

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.googlegr oups.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?

Differential Backup Script

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?

Differential Backup Script

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?

Differences in MS SQL7 and MS SQL2000

I am having difficulty convincing my management to upgrade from our existing MS SQL7 Database to MS SQL2K. I know that SQL2K offers enhanced performance and ease of use but am unable to find any white paper or documentation online that shows me the advantage of SQL2K over our current older version. Is anyone here facing the same problem as me? If any one has any documentation or hyperlinks to point me in the correct place, just post here or drop me an e-mail at chanmunyew@.msn.com to help...any help at all is greatly appreciated!! thanks guys!More links than you can shake a stick at, hope these help:

http://www.microsoft.com/catalog/display.asp?site=10145&subid=22&pg=4#167937

http://www.microsoft.com/sql/evaluation/overview/whatsnew.asp

http://support.microsoft.com/default.aspx?scid=kb;en-us;323049

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part1/c0261.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/whatsnew/wn_whatnew_7im0.asp

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itcommunity/chats/trans/sql/sq092700.asp|||Thanks!!!!!