How to restore standalone user database in to SQL Server 2008 cluster?

Hi,

Please provide complete solution for below request.

- How to move standalone user database to SQL Server 2008 cluster?

Thanks & Regards,
Chandra
Chandra Mohan KanithiPrincipal Consultant - DatabaseAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
First transfer logins.

Ms has a KN article on listing the current sql logins which can then be transferred to the cluster servers.

Backup/restore.  
The cluster has to be of the same or higher version.

Look at DB mirroring from the standalone to the cluster. ....
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Backup the database in the stand alone server and restore it in the cluster instance.
Or detach the database in the stand alone server, copy the .mdf and .ldf files to the cluster instance and attach the database there.

For both cases you'll need to copy the database logins that has access to the database otherwise you'll need to recreate them in the cluster instance. MSDN article about transferring logins.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
arnoldCommented:
no detach, why disable the currently functioning setup until it is clear that you have completed the migration to the new.

Detach/attach will likely loose the security settings configured on the database.

With the information at hand, the best way to manage a smooth transition is to use mirroring from the stand alone to the cluster instance and when the application is ready to transition fail the mirror from the standalone onto the cluster instance and one and done.

backup/restore on the cluster with out the database being online on the cluster instance, then using the mirroring config establish the standalone as the principal with the cluster instance as the mirror..
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.