Solved

Database Maintenance Plan

Posted on 2011-02-14
4
274 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 125 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to use TOP 1 in a T-SQL sub-query? 14 52
Query to Add Late Tolerance 10 85
Parse this column 6 38
Change this SQL to get all nodes 3 55
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
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 a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

732 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