Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Creating a new Management Data Warehouse and removing the old one Expand / Collapse
Author
Message
Posted Sunday, February 3, 2013 7:56 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 7:45 PM
Points: 29, Visits: 122
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
Posted Monday, February 4, 2013 5:41 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 31, 2014 10:27 PM
Points: 116, Visits: 347
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
Posted Monday, February 4, 2013 6:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, May 25, 2014 10:09 AM
Points: 283, Visits: 1,114
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.



Check Your SQL Servers Quickly and Easily
www.sqlcopilot.com
Post #1415262
Posted Monday, February 4, 2013 6:47 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 31, 2014 10:27 PM
Points: 116, Visits: 347
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
Posted Monday, February 4, 2013 4:30 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 7:45 PM
Points: 29, Visits: 122
Really? OK, I'll give that a go. Hopefully not too late to point it back to the existing database.

Thanks! :)
Post #1415525
Posted Monday, February 4, 2013 5:28 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 7:45 PM
Points: 29, Visits: 122
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
Posted Monday, February 4, 2013 5:53 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 7:45 PM
Points: 29, Visits: 122
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
Posted Tuesday, February 5, 2013 12:59 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 31, 2014 10:27 PM
Points: 116, Visits: 347
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
Posted Tuesday, February 5, 2013 5:12 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 7:45 PM
Points: 29, Visits: 122
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
Posted Thursday, February 7, 2013 6:58 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 31, 2014 10:27 PM
Points: 116, Visits: 347
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 »

Add to briefcase 12»»

Permissions Expand / Collapse