Friday, June 13, 2008

Backup and Restore Problem


here is a case when you want to restore WSS 3.0 site with Content database in SQL Server 2000 to wss 3.0 with Default Embadded Edition Microsoft##SSEE.

I have server "A" (Old server) where WSS 3.0 are installed. I have 2 sites created in WSS 3.0 and I have SQL Server 2000 on server "A".
Now I want to restore these four site on new server called "B" where WSS 3.0 installed with Default Microsoft##SSEE Sql instance.
so what should I do which is better and effective way to do this?
as there are two over load of backup from stsadm command in wss 3.0 which should I use.
1.Stsadm.exe -o backup -url http://a/ -filename "c:\backup\a_80.bak"
2.stsadm.exe -o backuo -backupmethod "full" -directoryname "c:\backup"
which one should I use?.
using second method of backup while restore on new server "B" I am getting error [SPManager] [ERROR] [6/9/2008 8:40:11 AM]: The signature of the public key is invalid.
Signing object:[dbo].[AllDocs]
[SPManager] [ERROR] [6/9/2008 8:40:11 AM]: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

while restoring WebApplication is successfully created but in second phase when it trying to attach contentdb with this webapplication it fires an error that remote connection is not enabled because its Microsoft##SSEE instance.

Solution is take backup from first method.. i.e.

1.Stsadm.exe -o backup -url http://a/ -filename "c:\backup\a_80.bak"

and restore it..

No comments:

Share your SharePoint Experiences with us...
As good as the SharePointKings is, we want to make it even better. One of our most valuable sources of input for our Blog Posts comes from ever enthusiastic Visitors/Readers. We welcome every Visitor/Reader to contribute their experiences with SharePoint. It may be in the form of a code stub, snippet, any tips and trick or any crazy thing you have tried with SharePoint.
Send your Articles to with your Profile Summary. We will Post them. The idea is to act as a bridge between you Readers!!!

If anyone would like to have their advertisement posted on this blog, please send us the requirement details to