Database freezes after a msSQL tcp restore

Asked By Adam Johnson 70 points N/A Posted on - 10/25/2012

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?

• Status: Open
• Question Views: 871
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Server Software

Best Answer by LyanaHay

Go To Solution

Answered By parker_carter 0 points N/A #136947

Database freezes after a msSQL tcp restore

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.

About parker_carter

Questions
1

Answers
98

Best Answers
24

• Vote Up 0 Vote Down

• Posted on - 11/08/2012
• Question Category: Server Software

Best Answer

Best Answer

Answered By LyanaHay 0 points N/A #136948

Database freezes after a msSQL tcp restore

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.

About LyanaHay

Questions
2

Answers
106

Best Answers
64

• Vote Up 0 Vote Down

• Posted on - 12/27/2012
• Question Category: Server Software