how to backup database 1

[lelo25]

Hello,
What is the best way to backup an sql server database,
using export or cold backup, and how to do it.
Regards,

 

[hmckillop]

If you have enterprise manager, right click on the database, select "All tasks", then Backup database.
When the Backup dialog appears select the following options
*Database - Complete
*Add a destination - allows you to specify the backup location and filename
Click OK

This is the simplest way to backup but obviously there are numerous more options available.

Hope this helps

"I'm living so far beyond my income that we may almost be said to be living apart

 

[lelo25]

thanks for ur reply,
IS there a way to write this task in batch job (command line)
or to schedule it .
thanks.

 

[NortonES2]

Create a maintenance plan to backup the database, then tis can be scheduled to run as required.

-------------------------------

If it doesn't leak oil it must be empty!!

 

[SQLBill]

Use the SQL Server backup commands:

BACKUP DATABASE mydb
TO DISK

(That's just a very basic command). Refer to the BOL, use the Index tab and enter BACKUP DATABASE for more information.

-SQLBill
BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine

Posting advice: FAQ481-4875