Multiple Copies of Backup Sets BACKUP BACKUPSET creates additional copies of backup pieces in a backup set, but does not create a new backup set. OUTPUT The "TO DISK" option specifies that the backup should be written to disk and the location and filename to create the backup is specified. backup database [test] to disk = nc:\\test20120419001.bak withinit,nounload,name=ndhchis backup,skip,stats=10,formatinit指定应重写所有备份集，但是保留媒体头。如果指定了 init，将重写那个设备上的所有现有的备份集数据。nounload数据库 1. BACKUP DATABASE [test] TO DISK = N’K:\FullBackups\test’ WITH COPY_ONLY, NOFORMAT, INIT, NA ME = N’test-Full Database Backup’, SKIP, NOREWIND, NOUNLOAD GO. This gives me, among other things: BACKUP DATABASE successfully processed 1931558 pages in 232.509 seconds (63.122 MB/sec). This example will create a backup file to the file system. BACKUP DATABASE testDB TO DISK = 'D:\backups\testDB.bak'; Tip: Always back up the database to a different drive than the actual database. -- step 1 USE master GO BACKUP DATABASE AdventureWorks TO DISK='c:\AdventureWorks_full.BAK' WITH INIT BACKUP LOG AdventureWorks TO DISK='c:\AdventureWorks_log1.TRN' WITH INIT, COPY_ONLY BACKUP LOG AdventureWorks TO DISK='c:\AdventureWorks_log2.TRN' WITH INIT --step 2 RESTORE DATABASE AdventureWorks FROM DISK='C:\AdventureWorks_full.BAK' WITH … This helps me know it is a transaction log backup, but it could be any extension you like. Performing the same script as above, but with ‘NUL’: BACKUP Back up flash recovery area to tape. I have a question concerning RMAN backup to disk. Back up level 1 to disk. I want to back up a database using this code. Back up level 0 to tape. This form of backup is used to back up a database backup created as image copies on disk to tape. My current database usage is as follows: Total: 17,239,646,208 Free: 8,048,582,656 Backup SQL Database to Custom Location. Tape contains a level 0 backup of the whole database from February 1, incremental level 1 backups for each day from Monday through the present day, and any archived redo logs for the whole week. The command is BACKUP LOG databaseName. SqlCmd -E -S MyServer –Q “BACKUP DATABASE [MyDB] TO DISK=’D:BackupsMyDB.bak'” Named SQL Server instance: SqlCmd -E -S MyServerMyInstance –Q “BACKUP DATABASE [MyDB] TO DISK=’D:BackupsMyDB.bak'” The above create a fully restorable backup copy of “MyDB” to the file “D:BackupsMyDB.bak” which can be used for disaster recovery. sqlcmd -S servername -Q "BACKUP DATABASE [DBName] TO DISK = 'C:\backup.bak'" It works. But if the backup file already exists, the data gets appended to the file instead of replacing the file.