Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Mirroring Expand / Collapse
Author
Message
Posted Wednesday, March 26, 2008 6:03 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 12, 2008 2:53 PM
Points: 18, Visits: 308
Hi all I am planning to setup mirroring but we have our doubts like how should we mirror the structural changes in the database.

Thanks!
Post #475164
Posted Wednesday, March 26, 2008 8:44 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:58 AM
Points: 2,280, Visits: 3,069
What do you mean by structual changes to the database? Mirroring provides a redundant copy of the data. What exactly are you trying to accomplish?



My blog: http://jahaines.blogspot.com
Post #475184
Posted Wednesday, March 26, 2008 8:56 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:36 AM
Points: 31,362, Visits: 15,823
Everything logged passes through. If you add a column to a table, it moves to the mirror.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #475188
Posted Thursday, March 27, 2008 1:42 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 3:44 PM
Points: 636, Visits: 5,019
What are the things that are not logged? I know truncate is not logged. Are there any other commands?


Post #475704
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse