Post reply

Mirroring

  • August 20, 2007 at 11:59 pm

    #176294

    Hey,

    I have a question about mirroring in SQL Server 2K5. I know that you can't access the data in the mirrored db but can i create a database on the mirror server and access it? So I have the live server mirroring to the mirror server but we want to use the mirror server as a test server.

    Is this possible?

    Thanks.

    Andrew

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

    http://www.unleashthefury.com

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

  • August 21, 2007 at 12:54 am

    #728199

    hi

    i think you can

    "Keep Trying"

  • August 21, 2007 at 3:22 am

    #728218

    You can create a database snapshot to access your mirrored database.

    Paul

  • August 21, 2007 at 7:15 am

    #728284

    Andrew, your question is a little ambiguous. Are you looking to create an instance of the mirrored database and use that image for testing, or are you looking just to use the server that holds the mirror for setting up a testing database (not necessarily an image of the mirrored db)?

    If you want to use a not-exactly-current version of the mirrored database, you can create a snapshot of it, and use that for testing. If you are looking to use the 'hardware' and have other databases on the mirrored machine, that of course is allowable. However, if the primary database fails and you have to 'fail over' to the mirrored database, won't you then have production and testing on the same machine? Will that be an issue in your environment?

    here's a link for further reading (copied from a different thread here in the forum) http://msdn2.microsoft.com/en-us/library/ms175511.aspx

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

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