I have server "A" (Old server) where SharePoint 2.0 and WSS 3.0 are installed. I have 2 site created in SharePoint 2.0 and 2 site 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:80 -filename "c:\backup\a_80.bak"

2.stsadm.exe -o backuo -backupmethod "full" -directoryname "c:\backup"

which one I should use.

as I want successfuly restore all sites to new server "B". Both SharePoint 2.0 and WSS 3.0 site.



but while restore on new server "B" I am getting error

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.



Note : My each site backup is of average 9GB. so I cant use SQL Express.