Results 1 to 3 of 3

Thread: How to Disaster recover from replicate DB

  1. 01-04-2007, 06:20 AM #1
    raghu_ktm
    raghu_ktm is offline Registered User
    Join Date
    Jan 2007
    Posts
    2

    How to Disaster recover from replicate DB

    Hi All,

    In MSSQL
    I create a replication for one DB1 to the another computer in same DB Name, replication is success but. What i need is If my working DB is Crash then how can i configure my replicate DB to continue my JOB please Help me !

    Thanks Lot !

    Raghu
    Reply With Quote Reply With Quote
  2. 01-04-2007, 09:26 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Have to switch all db users to server that hosts replicated db.
    Reply With Quote Reply With Quote
  3. 01-04-2007, 09:58 AM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    It is not straight forward.

    When doing tran replication, by default it removes all the constraints and identity property from your subscription database. and it will not replicate any new users, logins , functions etc.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules