Backup in MSDE

[DonS100]

Hello, I need to to a create a SQL Server 2000 job to perform a backup for a client. They're running Small Business Server 2003. I went on the machine
and I don't see Enterprise Manager. I see that there is a SQL Server directory with mdf and ldf files. Does this mean that they're running MSDE, if so how can you create jobs to run backups if you don't have Enterprise
Manager?

Thanks

 

[mrdenny]

You'll need to use the stored procedures to create the job. Look up the following in BOL:
sp_add_job
sp_add_jobschedule
sp_add_jobstep

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com