I'm trying to set up database mirroring in SQL Server 2008R2. I've taken a full backup and a transactional backup from my principal database and I've restored both
However, my mirror database is now stuck in
RECOVERING mode and when I hit "start mirroring" on my principal, it says it can't connect.
What am I doing wrong?
Edit: I should probably state that my database is rather large (the mdf file is about 4.8GB) so that could be why.
Edit2: I've also tried doing this with both firewalls turned off so I know it's not a firewall issue.
It's worth noting that I got the following error when I ran the query on the mirror: Msg 927, Level 14, State 2, Line 1 Database 'RHSCMSSites' cannot be opened. It is in the middle of a restore.