Solved

WSS2.0 restore not complete

Posted on 2010-09-23
6
566 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
Office 365 Advanced Training for Admins

Special Offer:  Buy 1 course, get 2nd free!  Buy the 'Managing Office 365 Identities & Requirements' course w/ Accelerated TestPrep, and automatically receive the 'Enabling Office 365 Services' course FREE!

 
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 250 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

738 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