Home Forums SQL Server 2008 SQL Server 2008 Administration sql server how to split a mirrored db on to multiple devices RE: sql server how to split a mirrored db on to multiple devices

  • April 8, 2013 at 4:40 am

    #1604325

    First question is

    Do the database file paths match on both servers?

    So, for instance if the database files on the Principal are located in

    D:\MSSQL_10.50.Prod\MSSQL\Data

    Does this path exist on the mirror or is the mirror using another path such as

    D:\MSSQL_10.50.Mirror\MSSQL\Data

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

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