?
Solved

Restore WSS_Content database

Posted on 2014-07-24
4
Medium Priority
?
778 Views
Last Modified: 2014-08-05
Try to restore a WSS content database from the backup and it can't. Guessing that the SharePoint is still hosting the content.

"Restore failed for Server'Portal'. (Microsoft.SqlServer.SmoExtended)
System.Data.SqlClient.SqlError:Exclusive access could not be obtained because the database is in use. (Microsoft.SqlServer.Smo)

Tks
0
Comment
Question by:AXISHK
[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
4 Comments
 
LVL 32

Assisted Solution

by:Jamie McAllister MVP
Jamie McAllister MVP earned 600 total points
ID: 40216156
0
 
LVL 19

Assisted Solution

by:Walter Curtis
Walter Curtis earned 600 total points
ID: 40217392
If restoring via SQL Server Management Tool, (whatever it is called), you can force an overwrite. Take the db off line first, and remember, if the restore is older then current, you will overwrite newer data. If this is disaster recovery it may be your only option. BUT BE CAREFUL PLEASE
0
 
LVL 8

Accepted Solution

by:
Jayaraja Jayaraman earned 800 total points
ID: 40217947
Did you make sure the DB you are trying to attach is not being used by any other services? if yes please stop other services being using it and try to attach it via powershell
eg:
Mount-SPContentDatabase “MyDatabase” -DatabaseServer "MyServer" -WebApplication http://sitename
or
Mount-SPContentDatabase “MyDatabase” -DatabaseServer "MyServer" -WebApplication http://sitename -NoB2BSiteUpgrade
0
 

Author Closing Comment

by:AXISHK
ID: 40243033
Tks
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

762 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