Restoring with NORECOVERY query executes indefinitely

Question

Post reply

Restoring with NORECOVERY query executes indefinitely

thotvedt

SSCommitted

Points: 1915
More actions
October 18, 2011 at 11:49 am

#250299

I am trying to set up mirroring, and when I restore the database to the mirror server using the 'NORECOVERY' option, the query just continues executing. It's been going for nearly an hour and it still says "Executing query...". The database itself is only 2 gigs. SSMS does show the database in place in the (Restoring...) state, as expected. Any thoughts?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

thotvedt SSCommitted Points: 1915 More actions · Answer 1

Nevermind. It just took forever. 30 seconds to back up and an hour and a half to restore.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Hmmm... This: http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 3

GilaMonster (10/18/2011)
Hmmm... This: http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx

Thx for the link!

My blog