<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 Administration
»
Creating a new Management Data Warehouse and...
11 posts, Page 1 of 2
1
2
»»
Creating a new Management Data Warehouse and removing the old one
Rate Topic
Display Mode
Topic Options
Author
Message
Draelith
Draelith
Posted Sunday, February 03, 2013 7:56 PM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:30 PM
Points: 29,
Visits: 117
When I took on the Role of DBA, i inherited some leftovers from the previous DBA. One such leftover was the fact that MDW was configured. The issue is the fact that the MDW database was stored on the C:\ of my server. Incredibly stupid.
So I have started running the configuration wizzard and made a new MDW database on the correct drives. But I'm not sure on what to do next. Will the wizard now setup the data collection jobs to point to the new database?
How do I remove the old database now? When is it safe to do so?
Thanks!
Post #1415087
SQL Pizza
SQL Pizza
Posted Monday, February 04, 2013 5:41 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116,
Visits: 293
Why don't you just query the new MDW-Database and take a look a the timestamp of the latest entries?
Greetz sql pizza
Greetz
SQL Pizza
sometimes you dont see the pizza for the toppings...
seek and ya shall find...
Post #1415248
Richard Fryar
Richard Fryar
Posted Monday, February 04, 2013 6:21 AM
SSC Veteran
Group: General Forum Members
Last Login: Monday, May 20, 2013 6:18 AM
Points: 242,
Visits: 882
Why create a new database? You could have just detached, copied files and attached again. The MDW collectors would have continued using the same database.
FREE DOWNLOAD
www.sqlcopilot.com
Post #1415262
SQL Pizza
SQL Pizza
Posted Monday, February 04, 2013 6:47 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116,
Visits: 293
Richard Fryar (2/4/2013)
Why create a new database? You could have just detached, copied files and attached again. The MDW collectors would have continued using the same database.
Exactly!
Just stop the corresponding collector jobs and deattach, copy and move an reattach!
Greetz
SQL Pizza
sometimes you dont see the pizza for the toppings...
seek and ya shall find...
Post #1415272
Draelith
Draelith
Posted Monday, February 04, 2013 4:30 PM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:30 PM
Points: 29,
Visits: 117
Really? OK, I'll give that a go. Hopefully not too late to point it back to the existing database.
Thanks! :)
Post #1415525
Draelith
Draelith
Posted Monday, February 04, 2013 5:28 PM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:30 PM
Points: 29,
Visits: 117
Well I have successfully detached, moved the database mdf and ldf files and reattached. So far so good. Now to just monitor the data collection tasks and see what happens.
Post #1415537
Draelith
Draelith
Posted Monday, February 04, 2013 5:53 PM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:30 PM
Points: 29,
Visits: 117
First issue:
The Data collection is failing because it's trying to go to the new database i created and I've set it to single user mode. I have since gone back to the wizard and pointed it back to the original database (on the new drives) but it still tries to go to the new database I created.
Should I delete the jobs, stop data collection and then try to setup data collection again?
Post #1415543
SQL Pizza
SQL Pizza
Posted Tuesday, February 05, 2013 12:59 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116,
Visits: 293
Hi Drealith,
first of all...if you click on the edit-button you can always edit your last posting and don't need to double- or triple post.
If you chose another Database to log to, you will have change it back to the old DB on the new drive. Logical, isn't it? If you can't do this, then set it up new.
Greetz
sql pizza
Greetz
SQL Pizza
sometimes you dont see the pizza for the toppings...
seek and ya shall find...
Post #1415620
Draelith
Draelith
Posted Tuesday, February 05, 2013 5:12 PM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:30 PM
Points: 29,
Visits: 117
That's the issue. I ran the wizard again and pointed it to the correct database, but the update still tries to connect to the database I created after the original.
I may try and delete the jobs and then run the wizard again in hopes it recreates them. I'll take a backup first just in case it doesn't.
Post #1416172
SQL Pizza
SQL Pizza
Posted Thursday, February 07, 2013 6:58 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116,
Visits: 293
Got it working now?
Greetz
SQL Pizza
sometimes you dont see the pizza for the toppings...
seek and ya shall find...
Post #1417049
« Prev Topic
|
Next Topic »
11 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
