asked on

SQL Restore Stuck at 'Restoring'

Experts,

I'm trying to set up database mirroring (between SQL1 and SQL2), with witness (SQL3), according to these guidelines, but the Restore of SQL's backup is stuck at Restoring.

Any ideas?

ttist25

Here's a link to a solution that I've used in the past. https://dba.stackexchange.com/questions/56169/sql-server-databases-stuck-in-restoring-state

In the article they state that it's usuall due to restoring with NO RECOVERY.

!!!!!!!!!!!Be careful there is a caution about the possibility of messing stuff up but I've never had a problem with it!!!!!!!!!!

I just did this two days ago:
RESTORE DATABASE [DataBase Name] WITH RECOVERY;

and I think I've also used this before:
ALTER DATABASE DBName SET ONLINE;

Michael L

ASKER

I've done it with NO RECOVERY without issue before, but the Mirroring does not like it. In the article I posted, it explicitly wants you to select NO RECOVERY.

I get an error 1418 when trying to Mirror to a Recovery WITH RECOVERY on.