SQL Server Performance Forum – Threads Archive

Restoring Backup

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

---

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.

---

Thanks

---

]]>