Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pkuchaliya
Starting Member
49 Posts |
 Posted - 2008-09-19 : 08:25:40
|
| BACKUP DATABASE pk_dataTO DISK = 'd:\database_backup\pk_data.bak' WITH COMPRESSION = 3 , MAILTO = 'pkuchaliya@gmail.com' i have give this command to backup the database but it generate the error :-'COMPRESSION' is not a recognized BACKUP option.as study online i found the syntax for backup BACKUP DATABASE { database_name } < file_or_filegroup > [ ,...n ]TO { DISK } = { 'physical_backup_device_name' | '<AUTO>' } [ ,...n ][ WITH [ [ , ] { CHECKSUM | NO_CHECKSUM } ] [ [ , ] COMPRESSION = { 0 | 1 | 2 | 3 } ] [ [ , ] { CONTINUE_AFTER_ERROR | STOP_ON_ERROR } ] [ [ , ] COPY_ONLY ] [ [ , ] COPYTO = { 'target_folder_name' } [,...n] ] [ [ , ] DESCRIPTION = { 'text' } ] [ [ , ] DIFFERENTIAL ] [ [ , ] ERASEFILES | ERASEFILES_ATSTART = { 'days' | 'hours'h } ] [ [ , ] FILEOPTIONS = { 1 | 2 | 3 | 4 | 5 | 6 | 7 } ] [ [ , ] INIT ] [ [ , ] KEYSIZE = { 128 | 256 } ] [ [ , ] LOGTO = { 'target_folder_name' | 'file_name' } ] [ [ , ] MAILTO = { 'recipients' } ] [ [ , ] MAILTO_ONERROR = { 'recipients' } ] [ [ , ] MAXDATABLOCK = { 65536 | 131072 | ... | 4194304 ] [ [ , ] MAXTRANSFERSIZE = { 65536 | 131072 | ... | 1048576 ] [ [ , ] MIRRORFILE = { 'physical_backup_device_name' } ] [ ,...n ] [ [ , ] NAME = { backup_set_name } ] [ [ , ] NOCOMPRESSWRITE | NOWRITE ] [ [ , ] PASSWORD = { password } ] [ [ , ] THREADPRIORITY = { 0 | 1 | 2 | 3 | 4 | 5 | 6 } ] [ [ , ] THREADS = { 2...32 } ] [ [ , ] VERIFY ]]pankaj |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-19 : 08:29:25
|
| That is feature supported in SQL 2008.You must be in SQL 2005.Am i correct? |
 |
|
|
|
|
|
|
|
backup problem please help