SQL Server/T-SQL Tutorial/Database/BACKUP

Backup a database with DIFFERENTIAL

   <source lang="sql">

BACKUP DATABASE NWCopy TO NWCopyBK_1 WITH DIFFERENTIAL GO</source>

Backup a database with init

   <source lang="sql">

BACKUP DATABASE NWCopy TO NWCopyBK_1 WITH INIT GO</source>

BACKUP DATABASE

   <source lang="sql">

5> BACKUP DATABASE pubs to disk = 6> "c:\pubs.bak"</source>