Ok here is my scenario.
I have a SharePoint 2007 farm, one front end server and one backend sql 2005 server. I want to install sharepoint 2010 on a new server and install sql 2008 on another new server. What I have done is,
installed sharepoint 2010 on a new box. Installed sql 2008 on a new box.
Ran the config wizard on 2010 and pointed to the new sql server
I took a backup of my sql db from 2005, copied it over to my new 2008 sql server, restored it and attached it to my main web app in sharepoint 2010
All works fine - i can browse all my old sites on the new sharepoint box, but the issue is now I want to mirror the database onto another sql 2008 box.
I take a backup of my database from the import into the 2008 sql box, and i copy it to my new mirrored sql server and i restore (no recovery mody)
once i restore, the new sql 2008 server just shows the database as (Restoring...)
even though it said it restored successfully.
It will not let me expand the database or restore the trn logs either.
I tried many times, rebooting and such and nothing will allow me to mirror the database due to it being in that restoring mode.