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?
Michael LPr. SysadminAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ttist25Commented:
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 LPr. SysadminAuthor Commented:
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.
Vitor MontalvãoMSSQL Senior EngineerCommented:
That's the expected behaviour for a mirrored database.
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

Michael LPr. SysadminAuthor Commented:
Can you elaborate, Vitor?
ZberteocCommented:
A mirrored database is always in restoring mode in order by be able to accept incremental log backups restores of the log backups done on the primary node. The mirrored databases cannot be used until they are activated.

If you want to make your mirrored database usable(readable) you will have to use the Availability Groups with the Always On feature, which is the next level of mirroring. Mirroring will be deprecated on later SQL server versions..
Michael LPr. SysadminAuthor Commented:
Do you have any guides on setting that up?
ZberteocCommented:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.