September 7, 2011 at 8:58 am
Hai,
I am trying to configure mirroring between principal and mirror servers without witness server.
I took the full backup and transactional backup of the database "Test_Mirroring" on the principal server.
Then I restored them on the mirror server with norecovery mode.
Now when I started configuring mirroring through Management Studio, I am able to successfully complete "Configure Security" options.
After that when selected "Start Mirroring" it is throwing error. I am giving you the details of the error below:
TITLE: Database Properties
------------------------------
An error occurred while starting mirroring.
------------------------------
ADDITIONAL INFORMATION:
Alter failed for Database 'Test_Mirroring'. (Microsoft.SqlServer.Smo)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Could not locate file '1' for database 'Test_Mirroring'. (Microsoft SQL Server, Error: 8985)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=8985&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Please help me how to resolve this issue as early as possible.
September 7, 2011 at 12:15 pm
Duplicate post. Please post answers here
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply