May 17, 2005 at 1:02 pm
Hey
I am trying to schedule a backup maintenance plan to backup all my db's. But it will never run. I was wondering if there is a way to do a complete backup of all my db's through the command line, so i could just stick it in a .bat file and have that scheduled.
Thanks
Matt
May 18, 2005 at 12:01 am
Instead of trying a different direction, try to find out why it will not run.
May 18, 2005 at 1:55 pm
Yes, you can do a backup from the command line. But I would agree that maybe you should look into why the maint plan will not run. Check to see what the jobs are running as (i.e. sa, user-id, etc.). Make sure you set the schedule for them to run. Make sure all SQLAgent is running and what it is running as. Can you run the jobs successfully if you manually run them. Also, make sure the databases in the plan still exist!!!
May 19, 2005 at 8:21 am
Thanks dbamark, I found out why they weren't running, it had to do with authentication, maintplan should work now.
Thanks again
Matt
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply