locked
Need help on setting up SQL 2008 Mirroring RRS feed

  • Question

  • Hi 

    I am planning to install fresh SQL Server 2008 with different LUNs for DATA and LOGS and TEMPDB.

    Latter I have a plan to mirror this server's one database with one existing server which has only one C:\ Drive and installed SQL in default program file location.

    My question is is it possible to do a mirror of production server with a server which has different directory structure for SQL ?

    OS and SQL Edition would be same.

    Thanks

    Vijay

    Monday, December 3, 2012 1:15 PM

Answers

  • Hello Vijay,

    No, its not mandetory, you can change it as per your requirement. The only requirement is the SQL Server editions and service pack levels should be same.

    Here, is a link to the step-by-step guide. 

    Hope, this may help :)



    SKG: Please Marked as Answered, if it resolves your issue. (b:http://sudeeptaganguly.wordpress.com )

    • Marked as answer by Maggie Luo Monday, December 17, 2012 5:21 PM
    Monday, December 3, 2012 1:53 PM

All replies

  • My question is is it possible to do a mirror of production server with a server which has different directory structure for SQL ?

    OS and SQL Edition would be same.


    Yes, you can setup mirroring irrespective of the drives or folder structures on principal and mirror as long as SQL Server build and Edition are same
    Monday, December 3, 2012 1:21 PM
  • Hello Vijay,

    You can use the following script to automate the database mirroring setup, 

    http://sudeeptaganguly.wordpress.com/2012/03/06/database-mirroring-with-sqlcmd/



    SKG: Please Marked as Answered, if it resolves your issue. (b:http://sudeeptaganguly.wordpress.com )

    Monday, December 3, 2012 1:25 PM
  • Hey Sudeepta,

    You mention same directory structure for Primary server and Mirror server in your script E:\SQL SERVER\USERDB\DATA\

    is it mandatory to set up mirror ?

    Thanks

    Vijay 

    Monday, December 3, 2012 1:46 PM
  • Hello Vijay,

    No, its not mandetory, you can change it as per your requirement. The only requirement is the SQL Server editions and service pack levels should be same.

    Here, is a link to the step-by-step guide. 

    Hope, this may help :)



    SKG: Please Marked as Answered, if it resolves your issue. (b:http://sudeeptaganguly.wordpress.com )

    • Marked as answer by Maggie Luo Monday, December 17, 2012 5:21 PM
    Monday, December 3, 2012 1:53 PM
  • Thanks Sudeepta.

    Will give it a try.

    Tuesday, December 4, 2012 6:05 AM