• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • Last Modified:

Sql 2005

We have multiple instances of sql 2005 running on our server, We have been advised to consolidate these into one instance to prevent slowdown on our ERP system.

How can I consolidate these instances into one?

Thank You
0
kapoc
Asked:
kapoc
  • 3
3 Solutions
 
YveauCommented:
detach every database on the instances you want to shut down,
attach them in the instance you want to keep running.

Should be a matter of minutes ... if you are talking less than 100 databases :-)

Hope this helps ...
0
 
YveauCommented:
... just the user databases of course ! Omit master, model, msdb and tempdb in this exercise !

Hope this helps ...
0
 
kapocAuthor Commented:
Thanks for the advice, I have been reading articles on detaching and attaching db in sql 2005. what method do you recemmend I use.

Thanks!
0
 
YveauCommented:
What do you mean by 'method' ? I am not a big fan of doing such important things by means of the SSMS, as any good DBA would agree with me ... write a SQL script for this task, test it, test it and test it and then give it another test before running it against a production environment. problem with the SSMS is the huge possibility of human error ... and you can't test it. There is no guarantee that you will not click the wrong button while performing the change on the Prod Env ....

The script in your case would be pretty straight forward, so really: use a script !

Hope this helps ...


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.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now