Home Forums SQL Server 7,2000 Performance Tuning How to use 2 sql server instances with datafiles on a SAN RE: How to use 2 sql server instances with datafiles on a SAN

  • July 19, 2010 at 2:03 am

    #1194737

    You have 3 options:

    Replication

    Logshipping

    Database mirroring with database snapshot

    Choose anyone for reporting.....ut yes again Trasactional Replication would be best option here