Post reply

mirroring

  • June 20, 2014 at 7:52 am

    #287019

    hello,

    we have mirroring in place.

    it takes table data from sql server server1 to server2.

    It does not seem to copy the things such as stored procs, functions, views, etc.

    1- Is it possible to set this mirroring so that it also copies what I mentioned above?

    2- Is mirroring the same as replication?

    3- is it possible to restore the latest backup of the production server and restore it into the mirroring server? this is so that the mirroring server will have all the production stored procs, views, etc.? this then avoids running the production changed stored proc or view in the mirroring server one by one.

    Thanks

  • June 20, 2014 at 9:29 am

    #1723638

    I think this was answered on another site:

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c99376d5-26ff-49ae-beaf-65d58aea13db/mirroring?forum=sqldatabaseengine

  • June 20, 2014 at 1:36 pm

    #1723702

    Mirroring creates an exact copy (mirror) of the database on the second instance. Everything in the database is kept completely in sync.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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