|
Home > Archive > MS SQL Server > January 2006 > Backup in MSDE
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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
| |
| Razvan Socol 2006-01-25, 3:25 am |
| 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
|
|
|
|
|