Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jccorner
Starting Member
20 Posts |
 Posted - 2006-03-13 : 16:43:09
|
| The problem is I'm trying to setup a maintenance plan for one of the servers but for whatever reason the settings aren't saved for the backup. I also am not able to see any options in the "remove files older than" combobox where I would expect to see day(s), week(s) etc... I've tried rebooting the server but still no options and my settings aren't saved. Anyone have any clue what I'm missing?? Appreciate any assistance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-13 : 16:45:14
|
| Are you a system administrator on this database server?Tara Kizeraka tduggan |
 |
|
|
jccorner
Starting Member
20 Posts |
Posted - 2006-03-13 : 16:52:51
|
| Yes, I'm using the sa account. I also am trying to do it remotely and not at the local machine because we don't have enterprise manager on that machine. I'm going to install enterprise manager on the local machine and then try to create the maintenance plan. |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2006-03-13 : 21:28:36
|
| you would be better served by not using the maintenance plan and setting up your own jobs and alerts. you will learn more and the plans tend to be bothersome to troubleshoot and maintain.====================================================Regards,Sean Roussyaka the merciless black hearted capitalist troublemaker"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-03-14 : 03:22:44
|
Is this MSDE? I've often seen it on MSDE.You should be able to script an existing Maintenance Plan from a "real server" and then modify and run that script against the server where you are having problemsKristen |
|
|
|
jccorner
Starting Member
20 Posts |
Posted - 2006-03-14 : 09:14:31
|
| I'm using SQL Server 2000 Standard Edition. Thrasymachus: I wanted to at least install a maintenance plan until I can design my own plan. That way at least I get a backup until that is done.Problem still exists. I installed the 2000 components onto the server and attempted to create the maintenance plan yet I'm still getting the same problem, settings still not getting saved. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-03-14 : 11:09:03
|
| I reckon it must be the same problem as I have had on (several) MSDE installations. I can't tell you what the cause is I'm afraid.Do you have a recent Service Pack installed (SP3a or SP4)?Kristen |
|
|
|
jccorner
Starting Member
20 Posts |
Posted - 2006-03-14 : 13:32:41
|
| Thanks Kristen, I also have found the reported issue with MSDE. It seems my problem coincides with 'error 8114 converting data type to tinyint'. When I searched for this I began to find other people with my problem. I'm downloading SP3a right now and hoping that fixes my problem. Will let you know as soon as I'm done. Thanks again all for you assistance. |
|
|
|
|
|
|
Problem setting up Maintenance Plan