• 2TB DB in Simple Recovery Model in local disk , how was the performance?

    recently i restored a 1TB backup available from SAN drive to SAN drive took around 4.5 hours. so you can expect more delay for backup and restoration.

    for no downtime(try the below but zero downtime never possible)

    Change DB to full recovery.

    Take full backup from old server.

    Schedule log backup for 1 hour or so.

    Create login,job,SSIS, alerts,DB mails etc on new server.

    Restore it on new server in fullbackup and log sequence.

    change applciation to point to new server and check.

    (in case of any issue rollback to old server and backup and log backup will be helpful for another restore)

    Regards
    Durai Nagarajan