Post reply

Database Mirroring.

  • October 18, 2006 at 11:34 am

    #174873

    Hi everyone.

    Forgive my ignorance , but this is a new task I am trying to understand.

    I am trying to set up database mirroring with witness server. All 3 servers are running SQL 2005 Developers edition SP1.

    Ok running the wizard all the way through, until the last section when you start mirroring.

    I get this error.

    TITLE: Database Properties

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

    An error occurred while starting mirroring.

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

    ADDITIONAL INFORMATION:

    Alter failed for Database 'AdventureWorks'.  (Microsoft.SqlServer.Smo)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.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)

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

    ALTER DATABASE command failed due to an invalid server connection string. (Microsoft SQL Server, Error: 1449)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=1449&LinkId=20476

    I can't seem to find any info on error 1449.

    can anyone help me out on how to correct this error, or anything I should go back and check on during the config.

    many thanks.

  • October 18, 2006 at 4:21 pm

    #666677

    I also had that error.  I finally achieved witnessed mirroring when I specified port numbers other than the defaults that the Wizard chose.

    Once it started working, it's been very smooth sailing.

    HTH

    Elliott

  • October 18, 2006 at 4:46 pm

    #666680

    Cheers Elliot , I have set the port numbers to be 7022 , rarther than 5022 which I think was the defaults.

    Any thing else I could check ?

     

  • October 18, 2006 at 5:03 pm

    #666681

    The only other issues I can think of to check are the service accounts for each of the 3 servers.  If the same account is used for each one, then you can leave the text boxes blank in the Wizard.  If not the same, then you must enter each one.

    Before mirroring can start, a backup of the principal database and a backup of its transaction log need to be made.  Then these backups must be copied to the mirror server and the database restored in "NORECOVERY" mode.  (First the database backup and then the T-Log backup applied to it).

    BOL has considerable info on how you can query the endpoints to confirm that they are active, etc., but I did not find this helpful.

    Elliott

Viewing 4 posts - 1 through 3 (of 3 total)

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