September 16, 2008 at 10:59 am
Hi,
I have to restore master database and msdb databases on the SQL Server 2005 clustered environment on both the nodes and I have to attach the user databases (mdf and ldf files). Can any one provide me the links or the stuff how to do. I had never done this in clustered environment. Please help me as its very urgent.
Thanks
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
September 16, 2008 at 11:16 am
Why do you have to restore them on both nodes? Curious. The restore on the one node should be sufficient correct? Is this for a build up or did the servers die?
I have never had to do a restore of master in a clustered environment but I can't think why it would be different. Follow BOL information for restoring system databases and you should be good.
You may want to exercise a call to MS for this as well as they will obviously walk you through the process from beginning to end. Might be nice if the crunch is on. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 16, 2008 at 11:47 am
Hi,
Earlier it was a standalone server and now the client wants it as a clustered one. So we had detached the db's and created the cluster environment and now want to restore system db's
Thanks
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
September 16, 2008 at 1:44 pm
I think you made a mistake there of not restoring when you had one node.
I haven't done this, but I'd be nervous about this. Not sure if there is clustered information that you need in master.
What are you missing from master? Logins? I'd restore this master on another server (instance), script out the logins and then run the script on the clustered instance.
September 16, 2008 at 1:55 pm
I would have performed that leaving the stand alone up and running.
Just install an extra on your cluster env. and then copy the users (ssis task) and move all databases.
Are there any special jobs in msdb, special features you implemented ?
If not, just script all jobs and implement them on your new cluster.
2 advantages :
1) you can still fall back to your stand alone server
2) no messing around with system dbs
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply