Wednesday, October 9, 2013

Database Mirroring Part IV Suspended (Error: 1453, Severity: 16, State: 1) Add Log files to Mirrored Database

How to add additional log files to Mirrored database?

If you add new transaction log file for the same folder at the time of configuration of mirroring there wont be any issues, whereas if you add a transaction log file in new folder on principal server (if that folder is not exists on the mirror server) then we will get the below error and Mirroring will goes into suspended state
Error: 1453, Severity: 16, State: 1 (In principal server)
CREATE FILE encountered operating system error 3(The system cannot find the path specified.) while attempting to open or create the physical file Path (In Mirror server)

To fix the issue we should create the folder in mirror server same as principal server then we can resume the mirroring.


No comments: