Post reply

Could Not Configure Mirroring between Principal and Mirror Servers

  • September 7, 2011 at 10:05 am

    #247516

    Hi,

    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)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476

    ------------------------------

    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 9, 2011 at 10:52 am

    #1379408

    First, check the path of the files of Principal and Mirror DBs- they should be if possible identical,

    then check account permissions.

    This can help-BOL: "Troubleshooting Database Mirroring Setup"

  • September 12, 2011 at 5:14 am

    #1379884

    The principal files are:

    logical datafile name 'Test_Mirror_Db' and physical path is 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test_Mirror_Db.mdf'

    logical logfile name 'Test_Mirror_Db_log' and physical path is 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test_Mirror_Db_log.ldf'

    The mirror files are:

    logical datafile name 'Test_Mirror_Db' and physical path is 'D:\sql2k5\MSSQL.2\MSSQL\Data\testmirror.mdf'

    logical logfile name 'Test_Mirror_Db_log' and physical path is 'D:\sql2k5\MSSQL.2\MSSQL\Data\testmirror.ldf'

    Regarding account permissions, could you please tell me which account permissions I should check.

  • September 13, 2011 at 12:09 am

    #1380417

    The paths do not need to be the same. Can you provide more details on the setup?

    Is this server part of a windows domain or a workgroup?

    What user account do the SQL server services run under?

    Exactly what details did you provide during the configure security wizard?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • September 13, 2011 at 2:24 am

    #1380455

    Try checking out if the login that you are using has permissions for alter. Ideally it should have sysadmin permissions.

  • September 13, 2011 at 2:50 am

    #1380460

    Hey, once again I went to the configure security settings and now I was able to start mirroring successfully. I don't how it worked. However thanks for ur patience towards my questions....:-)

  • September 13, 2011 at 3:16 am

    #1380469

    cheers Praveen

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply