Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Maintenance Routines

Posted on 2008-10-13
3
221 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

Suggested Solutions

Title # Comments Views Activity
Help Required 2 39
Downgrading MS SQL 2008 R2 Enterprise to MS SQL 2005 Standard? 12 65
Are triggers slow? 7 12
Substring works but need to tweak it 14 15
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

861 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