SQL Server Performance

Restoring Backup

Discussion in 'Getting Started' started by tfakih, May 8, 2007.

  1. tfakih New Member

    I was restoring database from backup. After restoring the complete backup, I was restoring Transaction Log Backup. in last Trn Backup file I forgot to select RESTORE WITH RECOVERY. How to bring database online without restoring the all backup again?Can u please guide.

    Thanks.
    Regards
    TFakih
  2. satya Moderator

    Open query analyzer or query editor and execute RESTORE <dbname> WITH RECOVERY again, that will bring up the database online.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. tfakih New Member

Share This Page