SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Rebuilding SQL Server environment


Rebuilding SQL Server environment

Author
Message
Kasnut
Kasnut
Valued Member
Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)

Group: General Forum Members
Points: 60 Visits: 111
I was trying to get steps to efficiently rebuild a sql server 2005 cluster environment on Windows 2008. Currently on Windows 2003 and sql server 2005. There are stability issues with the current step up. I want to rebuild the environment that has approximately 25 databases. What are the steps involved? What to do or How to move over the databases form the other environment ?
Steve Jones
Steve Jones
SSC Guru
SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)

Group: Administrators
Points: 143130 Visits: 19424
You are doing the equivalent of an upgrade here, side by side.

Moving databases: http://www.sqlservercentral.com/articles/Administration/movingyouruserswiththeirdatabases/2124/

For upgrades, this will help: http://www.sqlservercentral.com/articles/Upgrade/65872/

The big things are moving security, scripting out and moving jobs/packages, and ensuring you have patched/configured the new instance to match the old.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Kasnut
Kasnut
Valued Member
Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)

Group: General Forum Members
Points: 60 Visits: 111
What need to be script out and how to handle the master database and so forth. Moving from sql 2005 windows 2003 to Sql 2005 on windows 2008. The only upgrade is wto windows 2008. The windows 2008 cluster is already built. I have to install sql server 2005 and move over all databases.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search