how to create backup in sql 6.0 using sql command

[progvar]

Hi all,
i want to create the backup of sql 6.0 database using sql command
i used this command
BACKUP DATABASE test TO DISK = 'E:\test.Bak' but
it shows the error
Msg 156, Level 15, State 1
Incorrect syntax near the keyword 'DATABASE'.

but when i used this command in sql 7.0 it works fine


please provide help me
varinder sharma

[mwasif]

Hello Varinder,

I believe you are talking about Micorosft SQL Server. I am moving the thread to SQL Server forum

[shrimant]

C:\PROGRA~1\MICROS~3\MSSQL\Binn\SQLMAINT -S "Servername" -U "DBusername" -P "passowrd"  -D "Databasename" -BkUpMedia DISK -DelBkUps 2weeks -BkUpDB "Drive:\BackupFilePath"

Naote that "C:\PROGRA~1\MICROS~3\MSSQL\Binn\SQLMAINT" would change bepending on your SQL server anf binn path.

[progvar]

thanks for reply
i am not understanding your answer please can you breif it

thanks
varinder

[OuTCasT]

Backup database DBNAME to disk = 'FILEPATH'

[shrimant]

@progvar
Make a batch file with ".cmd" or ".bat" file and cut paste the following into the batch file with appropriate obvious changes. SQLMAINT is a Sql Server command line utility, which you could make use for UR purpose

"C:\PROGRA~1\MICROS~3\MSSQL\Binn\SQLMAINT -S "Servername" -U "DBusername" -P "passowrd" -D "Databasename" -BkUpMedia DISK -DelBkUps 2weeks -BkUpDB "Drive:\BackupFilePath""