how can backup the sql database by the script ?

Please give example how can make the script that it
backup the databases (two database) ?
I want to use script in the job scheduling by run the script
weekly bases.

By the enterprise manager easily can take backup. but we want
backup perform automatically weekly.

regards.

Mateen

BACKUP DATABASE { database_name | @database_name_var }
TO < backup_device > [ ,...n ]

hi Mateen,

If you want backup operation to be happened automatically then you can have one more option provided by sql server itself. "Scheduler". By using Schedule backup task whatever span you want to specify you can for backup operation.

Provided you SQL Server Agent running all the time. When you schedule something. it gets added as a Job in "Management > Sql Server Agent > Jobs" in Enterprise Manager. You can even change the job from there also.



Vinod Pawar
Software Developer
India

thanks for response.

backup by schedule is good, but for this, you have to Access (enter) the
enterprise menager with rights. I want that I write script and run it make
backup the database. just like in Oracle. In Oracle write script in text file
ie.
database startup nomount
start backup
path etc...........
.....

database mount
end backup

just like this. without accessing Enterprise Manager,
script run and make backup at defind path of hard disk.
it is possible in sql server 2000 ?

regards.

Mateen

Hi Mateen,

Then you will have to look for BACKUP DATABASE command on BOL and use it accordingly, as Ramanuj suggested.

Cheers!

_________________________
- Vijay G
Strive for Perfection