How to Move mirrored database files
The following article describes how to move the database files of a mirrored database to a new location without any downtime. Basically I have the following scenario:
The following article describes how to move the database files of a mirrored database to a new location without any downtime. Basically I have the following scenario:
I have configured database mirroring with database sansu as the principal and with following 3 instances namely,
Deepak —> Principal
DeepakSansu —> Mirror
DeepakTest —> Monitor
Safety FULL with Witness :
Well the answer for this ‘depends on the mode in which mirroring is configured’. If mirroring is configured in High Availability mode (Full safety) then we don’t need to worry about failover as the mirror server will form a quorum with witness and will initiate an automatic failover. The safety level can be set using the below command,
VidhyaSagar
| #
You can make use of Cluster.exe utility or powershell.
Cluster.exe sample
cluster group “Cluster Group” /move
Powershell sample
Move-ClusterGroup “Cluster Group”
Ganapathy
| #
Vidya,
How to move the Windows cluster from one node to the other node in command line
Senthilsjc
| #
Usefull Session. Please Keep it up,,
veeresh
| #
Not yet tested might be very good feature..
VidhyaSagar
| #
Probably Encryption might be set, so go to reporting server configuration wizard and then click on Encryption tab. Once you are there take a backup of the existing key and then delete it. Now you will be able to point it to new db