Solved

Why do I get the attached error message when I attempt to restore a WSS 3.0 site?

Posted on 2011-02-11
2
373 Views
Last Modified: 2012-05-11
When I attempt to restore a WSS 3.0 Site (Content DB) in SQL Express 2005 Studio Management (Tasks>Restore), I get the attached error message.

Please advise how to resolve this issue. Thanks
Picture-2-06-19-05.png
0
Comment
Question by:PDSWSS
2 Comments
 
LVL 14

Accepted Solution

by:
GeorgeGergues earned 500 total points
ID: 34871693
This means you have live connections to the database.

the best way to do this would be to see the connections and terminate connections.


One way of doing that would be to
[1] Stop the SPTimer server (where applicable )
[2] Stop the SP administration service .(where applicable )
[3] Stop the WWW service on all the web servers.


Best of luck.
0
 

Author Closing Comment

by:PDSWSS
ID: 34872763
Excellent answer. Fixed the issue immediately. Thank you
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sharepoint 2010 Auditing 4 20
email about the whoisactive result 7 29
Help Extract Specific in SQL 8 27
Error running stored procedure 11 19
On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now