Database freezes after a msSQL tcp restore

Asked By 70 points N/A Posted on -
qa-featured

I decided to do a mssql tcp restore, first of all I backed-up my data, the problem came when I tried to restore the database, it froze in the restoring state. What could be wrong?

SHARE
Best Answer by LyanaHay
Answered By 0 points N/A #136947

Database freezes after a msSQL tcp restore

qa-featured

Hi Adam!

If you didn’t have disk space issues when restoring your database, then you need to use the recovery option. The command is:

"RESTORE DATABASE <DatabaseName> WITH RECOVERY"

Or

"RESTORE DATABASE DatabaseName FROM DISK = ‘DatabaseName.bak’ WITH REPLACE, RECOVERY"

You can run the query against the SQL Server instance. The database will immediately be usable.

Best Answer
Best Answer
Answered By 0 points N/A #136948

Database freezes after a msSQL tcp restore

qa-featured

Hi Adam Johnson,

Try these solutions:

1]  This error may occur if you have not selected option to restore database with recovery.  So I will recommend you to choose option to restore database with recovery so this problem will be solved.

2] Use restore database wizard in SQL server management studio which will make you to enable recovery, choose file location and overwrite options.

Related Questions