Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Database Maintenance Plan

Posted on 2011-02-14
4
Medium Priority
?
279 Views
Last Modified: 2012-05-11
Hi,
New to MSSQL Administration. We have a maintenance plan configured to store to disk. But the plans does not state which disk. There are mdf file with the same name on two different drives on the same server. The properties of the DB state the data directory is the E drive but there is a mdf file with the same name on the C drive. Trying to determine if the C drive is where the main plan is storing to.
Thanks.
0
Comment
Question by:centem
[X]
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
  • 3
4 Comments
 
LVL 5

Assisted Solution

by:robertg34
robertg34 earned 500 total points
ID: 34890764
So you are looking at (from Sql Server Management Studio) the "management" folder then the "maintenance plans" folder and opening your maintenance plan?  It sounds like a backup job?  

With these two assumptions:
You should see a backup database task.  Double clicking that will show you what folder you are backing up to.  
0
 

Assisted Solution

by:centem
centem earned 0 total points
ID: 34895588
Thanks for your response robertq34.
After douple clicking the right pane shows three boxes pointing in this order:
Back up Database Task -> Maintenance Cleanup Task -> Maintenance Cleanup Task 1
Under "Back Up Database Task" the destination states "Disk". What disk?
Thanks.
0
 

Accepted Solution

by:
centem earned 0 total points
ID: 34895697
Nevermind my last statement. Thanks. I found it.

within the "Backup Up Database Task" box right click on the clip board icon and then click edit. It shows up there.
0
 

Author Closing Comment

by:centem
ID: 34995319
I found my own solution by further poking around the interface.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

610 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