• Hi all

    Right now our plan got changed and we are planning to move only UDB's

    This is the action plan I perpared for Moving Databases between the servers,

    Action Plan:

    1.Change all Source Server Databases Database Recovery Modes in Full and

    Set Transaction Log backup(What ever flexible timing)

    2.Take full Backup all Databases and Restore in to destination Server WITH RECOVERY

    3.Move the ALERTS,JOBS,OPERATORS

    4.Move the DTS packages

    5.Make Sure that every Database is Moved

    6.Fix Login in Destination Server(Orphan Users).

    (what every application using /Database using)

    7.Again Backup all Databases and Restore in to destination Server. WITH NORECOVERY

    8.Apply the Transactional Backup’s WITH NORECOVERY Up to Databases server are in Sync

    9.Once Databases are in Sync Apply last transactional backup WITH RECOVERY

    Please give you suggestion.what every you feel.