August 5, 2015 at 7:24 am
Hi All,
I need some clarificantion about adding file in to mirrored dataabse in primary server without downtime and breaking the mirror server.
In our environment we are using monutdisks in both the servers. in primary for ex we have F drive for data files under mount disk 3 in mirror server also we have same drive but in mount drive2.
As per my knowledge if it is same drives we can add the ndf files in the primary that will reflect on mirror. but in current situation i am confusing about mount points with different names.
Please suggest how to proceed on this.
August 5, 2015 at 10:16 am
New persopn (8/5/2015)
Hi All,I need some clarificantion about adding file in to mirrored dataabse in primary server without downtime and breaking the mirror server.
In our environment we are using monutdisks in both the servers. in primary for ex we have F drive for data files under mount disk 3 in mirror server also we have same drive but in mount drive2.
As per my knowledge if it is same drives we can add the ndf files in the primary that will reflect on mirror. but in current situation i am confusing about mount points with different names.
Please suggest how to proceed on this.
If the paths match between servers you'll have no issue. If the paths are different, for example
Principal datafile on
D:\mountedfolder1\mssql\data
Mirror datafile on
D:\mountedfolder2\mssql\data
Then you'll have an issue, this link details how to fix a failed add file operation
https://msdn.microsoft.com/en-us/library/ms189127.aspx#FailedCreateFileOp
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2015 at 12:47 am
Thank you for your information. yes we have different mount points. in this case how can we add the file whether we need to break the mirroring or Pause the mirroring is also fine.
August 6, 2015 at 4:47 am
New persopn (8/6/2015)
yes we have different mount points. in this case how can we add the file whether we need to break the mirroring or Pause the mirroring is also fine.
Read the link I posted above 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply