sql syntax for making a backup to a file

[michelleqw]

Dear sql server users,

Is the any sql syntax for making a backup to a file.

For example: backup tbl_backup to "c:\mybackup"

If yes, can someone give the syntax?

Michelle.

 

[1DMF]

Is there a reason why you don't do this via the SQL EManager - 'Management' / 'Jobs' section.

This is how we create a .BAK file of all our databases.

 

[JamesLean]

Michelle, look up the BACKUP command in BOL. There is plenty of information and syntax in there.

--James

 

[michelleqw]

yhanks for the info.

Michelle.

 

[SQLBill]

Also, look in the FAQ section for this Forum.

-SQLBill

Posting advice: FAQ481-4875