• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 65
  • Last Modified:

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


Please provide complete solution for below request.

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

Thanks & Regards,
Chandra Mohan Kanithi
Chandra Mohan Kanithi
  • 2
1 Solution
First transfer logins.

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

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

Look at DB mirroring from the standalone to the cluster. ....
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.
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..
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now