backup

[sky_00]

have installed sql 2000 server.
how to create nightly backup of MyDatabase database at 11PM stored to c:\MyDtataBaseBackup (this can be mixture of complete and incremental)?.

[hspc]

Hi
In the enterprise manager :

right click the database you want to backup
All tasks ->backup database
Choose the options you need (file path / etc)
check the schedule Check box in the bottom of the screen
click ...
Select recurring radio button
Click Change
Select daily and adjust the time..

[sky_00]

then, how to restore from c:\MyDatabaseBackup folder to MyDatabase database?.

[hspc]

right click the database you want to backup
All tasks ->Restore database
Check From device
Click Select devices
Click Add
Locate the file
OK
OK
and you are done ;)