January 23, 2008 at 8:02 am
Hi All,
Can anyone please explain how to schedule a backup job in SQL SERVER 2005.
Thanks in Advance
January 23, 2008 at 8:22 am
If you are doing the backups with a script, then setting up the job is basically the same as it was in SQL 2000. The Management studio interface is slightly different, but it does the same thing when you get down to it.
If you are referring to how to set up a maintenance plan like you could in SQL 2000, it is also slightly different. If you are in Management Studio, expand the management folder and 'Maintenance Plans' is one of the folders. Right click on it and you can create a new plan. I played with this a little bit with the RTM version of SQL2005, and found it to be very buggy. It may have improved in SP1 or SP2.
My preference has always been to just script the backups (and in come cases, use xp_cmdshell to call a zip utilitie's command line interface to save disk space) and run them from a job.
The Redneck DBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply