November 25, 2014 at 7:44 pm
I have an existing standalone SQL Server instance. I'm setting up a new clustered environment. I know how to move user dbs, but when it comes to moving the system databases I've found two options: restore master and msdb or script out logins, jobs, linked servers, operators, credentials, etc. What I can't determine from my research is if I can restore system databases from a standalone instance to a cluster instance. I was wondering if any cluster settings would be overwritten if I restore from a non-clustered instance.
Thanks.
Lisa
November 26, 2014 at 3:11 am
Yes, they would be. It'd be a bad choice to do this after setting up a cluster. I'd suggest going the method of scripting everything for your initial deployment.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 26, 2014 at 5:21 am
In a clustered environment there are various pieces of meta data that are stored which you wouldn't see in a standalone environment.
Likelihood is if you do this it will fail to bring the instance online, never tried it myself and never would.
Script the objects out and migrate them across, there are plenty of scripts available if you look, SSIS even has some builtin tasks for this too.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 26, 2014 at 7:19 am
Thanks. That's what I was thinking, just wanted to confirm.
Lisa
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply