Solved

Sql 2005

Posted on 2007-11-23
4
188 Views
Last Modified: 2010-03-19
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
Comment
Question by:kapoc
[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 18

Assisted Solution

by:Yveau
Yveau earned 500 total points
ID: 20340162
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
 
LVL 18

Assisted Solution

by:Yveau
Yveau earned 500 total points
ID: 20340164
... just the user databases of course ! Omit master, model, msdb and tempdb in this exercise !

Hope this helps ...
0
 

Author Comment

by:kapoc
ID: 20344331
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
 
LVL 18

Accepted Solution

by:
Yveau earned 500 total points
ID: 20346342
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

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Suggested Solutions

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
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…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

726 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