Solved

Attach Database SharePoint 2007 to 2010 then SQL 2008 Mirror BOMBS

Posted on 2010-08-23
4
470 Views
Last Modified: 2012-05-10
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
Tested OK.
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.
0
Comment
Question by:jdisorg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 21

Accepted Solution

by:
chapmanjw earned 500 total points
ID: 33506117
What type of replication are you trying to setup?

I have had success in an Active/Passive SQL cluster by having the cluster and SQL instance setup first.  Then connect to the instance name (not a specific node) and restore the database.  Then attach it to the SharePoint farm.
0
 
LVL 2

Author Comment

by:jdisorg
ID: 33511125
Im trying to do a mirror, with no witness for the time being. I am going to wipe that db from sharepoint, then try the mirror.
Ill see what happens and reply back.
0
 
LVL 2

Author Comment

by:jdisorg
ID: 33511132
BTW i meant to say I know the mirroring works as far as firewall and network go, as i created a simple database and mirrored it over fine.
0
 
LVL 2

Author Closing Comment

by:jdisorg
ID: 33514734
That completely did it, removing the database from the web app in spoint allowed the mirror to go thru fine. I REALLY APPRECIATE YOUR HELP!
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question