Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

WSS2.0 restore not complete

Posted on 2010-09-23
6
Medium Priority
?
580 Views
Last Modified: 2012-06-22
Hello;

I just using "stsadm -o restore" utility to restore WSS2.0 sharepoint site to my test lab server.  The restore is done but when I compared it with the original production WSS 2.0 server, not every document restored.  And some sites are not able to access.  For exceple, there is a site for IT but I do not see it in my test server.

I created a short cut link to this site
\\companyweb\DavWWWRoot\site_10

but this site is not in my test server.

Also, the DavWWWRoot cannot be found on my test server, does it make sense?  Is it because I am using two different version of sql on production and test server?

On production server, I am using SQL 2000 on Windows 2003 32-bit.

On my test server, I am using SQL2500 on Windows 2003 R2 x64.

Also, when I use "stsadm -o enumsites -url http://companyweb" to list what is my sites in server but I got this result only, however; I have a lot of sub-sites, am I using the wrong command?

<Sites Count="1">
  <Site Url="http://companyweb" Owner="WEB\administrator" />
</Sites>
0
Comment
Question by:KANEWONG
[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
  • 3
6 Comments
 
LVL 9

Expert Comment

by:irinuc
ID: 33751838
Hi,

When you restored the site collection did you get any error/warning? Did you create the backup with a prod farm account? Did you restored with a test farm account?

stsadm enumsites displays only the site collections, not all the sites in the environment.
I would suggest you connect with a test farm account on http://companyweb and check the site hierarchy link. You can navigate to it from Site Settings->Go to site administration->View Site hierarchy.
Or directly: http://companyweb/_layouts/1033/vsubwebs.aspx
This should display the list of all sites.

Also, one thing to consider: the two farms have similar settings? Like for example are the same users defined, are the same third party tools installed or they are in completelly different configurations?
0
 
LVL 1

Author Comment

by:KANEWONG
ID: 33755209
there is no error during restore, just taking 10 hours to complete.  My test server is joined to the same domain as the production sharepoint server.  so, all accounts is the same.

Yes, I found out that I have to use "stsadm -o enumsubwebs -url ...." command to list all sub-sites, not enumsites switch.
0
 
LVL 9

Expert Comment

by:irinuc
ID: 33755406
So there is a single subsite restored?

The differences between the 2 servers may cause this; specially since the database structure was changed from one version to another.
I have never tried this type of backup/restore so I am not entirelly sure if this works; i need to check some more on web; one thing that i would check is that the dabatase is set to be compatible (should be 80, not 90)
0
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.

 
LVL 1

Author Comment

by:KANEWONG
ID: 33755510
I think, I did to set the database to be compatible with SQL2000.  Because this is a test server, I can retry many times as I want.

May be, I try one more time to see what is the difference and making sure that the compatibility option is enable.

Do I need to make the STS_config database to be compatible with SQL2000 too?
0
 
LVL 9

Accepted Solution

by:
irinuc earned 1000 total points
ID: 33755843
Now, I think you may encounter other issues on this path.
And I wonder if maybe it would be easier to create a backup of the batabase and attach it to the test farm.

See this thread for some more details. They talk about upgrading to Sharepoint 2007, indeed, but the basics are the same: backup the database, restore to the test SQL server and attach it to the test farm.
http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/5a5f42eb-b2a2-4048-92c4-c08d3c2715d8
0
 
LVL 1

Author Comment

by:KANEWONG
ID: 33755981
thanks for your link.    Now, I started another round for using stsadmin -o restore to restore my site and see how it work.  If still no luck, I will try the steps in link.

If it still not working, I will post another question. So, I close this question first and don't hold up long.
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

670 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