?
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
Medium Priority
?
384 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 2000 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

578 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