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 ther're running MSDE,
if so how can you create jobs to run backups if you don't have Enterprise
Manager?
Thanks
Hi, Don
You can create jobs using sp_add_job, sp_add_job_step,
sp_add_job_schedule and sp_add_job_server. You can execute a T-SQL
script using OSQL. See Books Online for more informations. It may be
easier to see how Enterprise Manager calls these procedures, using
Profiler (on another computer with the full SQL Server installed).
Razvan
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment