Bring Database Online

Hi,

One of our database size 90 Gb was backed up and restored on a standyby server with NoRecovery option .A Stored Procedure was written to do production Database transaction log Backup every 15 min and restore the Tlog File on Standby server.

Once the last transaction log file is restored on standby server the tlog file is deleted.

Now due to some reason the restore tlog job failed but the tlog file got deleted.

Now till we will not restore the last database backup we will not be able to start the restore tlog job.

Now the database is in restoring mode.Is there any methord to get that database online without any transactionlog.

Regards

Sufian

Inorder to bring the db online try the following,

Restore database DBName with Recovery....just let me know if the db has come online.......

|||You could just bring it online, however, a better option may be to perform a differential backup and restore that backup with norecovery. This will include all of the transactions since the last backup, and should allow you to resume your trans log backups once it has been applied.
Tim