?
Solved

Database Maintenance Plan

Posted on 2011-02-14
4
Medium Priority
?
277 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

770 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