Yesterday at 2pm I started a restore of a very small database. It is now 0745 on the next day and it is still in the RESTORING state. It can't take this long. Does anyone know what I can do? I need to get this database back up, even if it is the version before the restore.
Any help ASAP would be appreciated!!
Thanks so much.
Quote:
Originally Posted by sawtooths
Hello,
Yesterday at 2pm I started a restore of a very small database. It is now 0745 on the next day and it is still in the RESTORING state. It can't take this long. Does anyone know what I can do? I need to get this database back up, even if it is the version before the restore.
Any help ASAP would be appreciated!!
Thanks so much.
I had a restore lock up on me once.
I had to restart SQL Server.
I know this is a horrible solution, but in my case it was on a demo box, so it was bearable.
No comments:
Post a Comment