lsalih (5/10/2013)
Hi -We have a standalone SQL box that we need to migrate all the DBs to a new clusted environment that we will be building. The storage team with me detaching the existing storage desks from the standalone to the clusered servers so we do not move databases, just attach them back to the new clustered servers.
I once inherited an environment where this had been done before and i had to rebuild\install the cluster!
There are various configuration items held in the system database and in the folder where the system databases reside, don't do it!!
lsalih (5/10/2013)
The question I have is howto handle the system databases. From some links I see that others recommend restoring system databases, and then attaching the databases. Can you please tell me what is the best way is to handle the master database? Do you restore the master first, then do msdb and model DBs afterwards?
Don't move system databases between instances, especially standalone and clustered, script out any objects and apply them to the new system.
lsalih (5/10/2013)
The two new nodes we have need to be clustered? Is it better to first make the two nodes set as clustered and then have the storage team do the actual attachments to disks the day we go live?! What is the best way to set the clustered environment?
Setup a new cluster with its own storage and move user databases across and script out any objects you require (jobs, users, etc).
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉