Solved

Maintenance Routines

Posted on 2008-10-13
3
220 Views
Last Modified: 2010-03-19
I recently took over administration of a SQL 2005 Server with some problems for a new client. Apparently then had migrated directly from SQL 7 to 2005. Currently I am unable to add any of the user created DBs to a maintenance routine. They are not visible to select when I start an new maintenance routine so I am having to manually back up these DBs on a daily basis. I have noticed that their compatibility level is SQL 7, could this be the problem? Please advise, any ideas would be greatly appreciated.
0
Comment
Question by:jcraft10
3 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 250 total points
ID: 22706404
Maybe...although I am not sure. Why can't you create a maint plan to do it?  First things first, you're going to want to set the db compatability from 7 to 90 (sql 2005).  Once you've done that, try to create a maint plan from scratch.
0
 

Author Comment

by:jcraft10
ID: 22706463
I am attempting to create a maint plan from scratch, but the DBs in question aren't available as selections. The system DBs are there, just not the user created ones. I am concerned that upgrading the compatibility level of those DBs will disrupt the app on the front end. I'll give it a shot after hours and see what shakes out.
0
 
LVL 24

Assisted Solution

by:DBAduck - Ben Miller
DBAduck - Ben Miller earned 250 total points
ID: 22707090
When you have databases that are in compatibility modes other than 90 then the databases will not show up in the Maintenance Plan selections.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question