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
Please provide complete solution for below request.
- How to move standalone user database to SQL Server 2008 cluster?
Thanks & Regards,
Chandra
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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..
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..
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. ....