December 1, 2006 at 2:49 pm
In SQL 2000 & 7 it was easy to setup a recurring backup via ENt Mgr. You right-click the DB and select backup and after filling out the necessary info about what you are backing up and when there was a 'Schedule' button that allowed you to specify a schedule for the backup. As best as I can tell in SQL 2005 there is no way to setup a scheduled Backup by right-clicking on the DB and selecting Backup. The only way I can find to setup a scheduled backup is by explcitily setting up a new job along with a schedule and that just seems very difficult and akward for users with very simple backup needs. I did play with the DB Maintenance Wizard and aloowed it to create the scheduled Backup however when I tried to examine the details of the job I found that the Wizard had set up the Job to use Integration Services for the only step I had specified which was the DB Backup. And when I try to see the actual properties of that step by clicking Edit I am unable to get anywhere within the details screen; keepimng getting the message that I must select a Package first however I see no where to select a package.
What gives? Why can't I easily create a scheduled backup in SQL 2005? AM I just missing something or has 2005 made what was once simple now complex?
And does anyone know why the Wizard went with Integration Sevices on the Full Backup step instead of a simple T-SQL command?
This is very disappointing. I work in support and we have many clients without true DBA's who depend on simplicty for things like setting up a recurring backup and it looks like SQL 2005 has missed the target with simple tasks like this. Someone plesae show me that I'm wrong and that it is easy in 2005 and that I just am not seeing how to do this.
Thanks
Kindest Regards,
Just say No to Facebook!December 1, 2006 at 2:55 pm
If you register the server then connect to it in the object explorer you can right click on the database and it will give you the same thing as EM.
December 1, 2006 at 3:00 pm
<<If you register the server then connect to it in the object explorer you can right click on the database and it will give you the same thing as EM. >>
If that's true then where is the 'Schedule' link on the Backup screen that was on the Backup screen in Ent Mgr for SQL Server 2000?
Thanks
Kindest Regards,
Just say No to Facebook!December 1, 2006 at 3:00 pm
Sorry didn't read this through you want to schedule a maintanance plan with the wizard if they do not have a DBA there to script a job out.
In Management Sutdio you want to expand management the right click maintainance plans and use the wizard.
December 1, 2006 at 3:05 pm
<<Sorry didn't read this through you want to schedule a maintanance plan with the wizard if they do not have a DBA there to script a job out.
In Management Sutdio you want to expand management the right click maintainance plans and use the wizard. >>
If this is really true, meaning using the Wizard is the only simple way of doing this then it seems like SQL 2005 (at least the management tool) is a step back in the area of backup simplicty. If you use teh Wizard to create a scheudled backup and select 'Backup' when getting to the screen to select what you want done, you end up with a complex Integration Services task instead of a simple T-SQL backup command and it seems impossible to get into the details of that task and change anything about it. Granted I haven't sat thru any tutorials on using the SQL Management STudio tool however I would think that anyone who is comfortable with doing simple backups in SQL Server 2000 using ENt Mgr shouldn't have this hard a time doing something similiar in SQL 2005. Am I just wrong for thinking this way? SHould SQL Server 2005 users be expected or even required to do more ocmplex backup procedures even if all they want is a simple full backup on a simple daily schedule?
Thanks for the replies!
Kindest Regards,
Just say No to Facebook!December 1, 2006 at 3:12 pm
I can tell you one thing I have invested a few weeks looking into the best 2005 management tool because everyone I work with also hates the new Management studio.
December 1, 2006 at 6:33 pm
I can tell you one thing I have invested a few weeks looking into the best 2005 management tool because everyone I work with also hates the new Management studio.
Well I definately do not hate the new SQL Management tool, in fact I like it better then Ent Mgr and QA in many areas say for a few such as the Scheduled Backups issue listed here. I prefered QA'a ability to perform searches (F4) which is missing in Management Studio. I also dislike the overhead needed in 2005 to run a simple query. Having to load the bulky Management Studio everytime you neeed to run any T-SQL seem slike over kill. What is needed is a way to load and use the Query tool in Management Studio without having to load Management Studio itself; like a Query Lite.
BTW - I do apreciate your responding to my post.
Kindest Regards,
Just say No to Facebook!December 2, 2006 at 9:56 am
I agree about the "query lite".. as for your simple backup.. if you don't want to run through the wizard (which is really really simple and flexible),or create a maint plan you can set up the backup as a job.. its not as intergrated but is as close as your gonna get.. just go through the Backup option and then script it out.. use that as your tsql task in your job and pick your schedule.. Its doesn't give you the flexibility of the maint plan but it doesn't give you the SSIS-ish interface like the Maint Plan setup.
Btw.. what searches are you missing? A text search through a query/proc window? Ctl-F and (f3) should get that doen for ya..
Thanks
Rich
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply