Hello I have a SharePoint environment contains 2 servers · Server running SharePoint server 2007 · Server running SQL server 2008 which contains the SharePoint data base I have created a similar environment to test SharePoint upgrade from 2007 to 2010 but consists of one server running moss and SQL Now I followed these steps to move the SharePoint site to my test server · I deattached the SharePoint data base using SQL (.mdf) · I have a back up from the site using the following command SET STSADM="C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\bin\stsadm" %STSADM% -o backup -url http://localhost:3060 -filename "c:\08062010.bak" Pause · I attached the data base to my SQL · I created a new web application on my server · I added the data base file as a new content data base to this web application · I created a new site collection · I tried to restor the sharepoint site using this command SET STSADM="C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\bin\stsadm" %STSADM% -o restore -url http://man-portals-004:2007/sites/Test -filename "D:\Test\08062010.bak" -overwrite %STSADM% -o execadmsvcjobs pause now i have this error the site collection couldn't be restored. if the problem persists please make sure the content databases are available and have sufficient free space I checked the space and it's enough also I have an admin permission also I don't know where is the problem Also I tried to use Import – Export commands and I failed import SET STSADM="C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\bin\stsadm" %STSADM% -o import -url http://man-portals-004:2007/sites/Test/default.aspx -filename "D:\AS\projects\Test\Phase 2\Back up\8-6-2010\08062010.cmp" pause export SET STSADM="C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\bin\stsadm" %STSADM% -o export -url http://ajlanpro:36784 -filename c:\site -includeusersecurity -overwrite -versions 4 pause please I need help to solve this issue and what is the best practices to do this operation

When you say you have enough disk space, is on c:\ or d:\ drive "verify on both disk"? this is very important because when you restoring database using stsadm will need some disk space on drive c:\ for the restore time, if the disk dont have the enough time then i belive the error will show, i can recomend attach the database Sharepoint content from Prodution database Server to your enviroment using sql Server management Studio on the correct drive, then you create your webapplication and site collection to associate your restore Sharepoint database using stsadm command lines "stsadm -o addcontentdb -url http//[URL] -databasename [Database name ex:WSS_content_attachdatabase]" Andr Lage Microsoft SharePoint, CRM and Sybase Consultant Blog:http://aaclage.blogspot.com Codeplex:http://spupload.codeplex.com/http://simplecamlsearch.codeplex.com/

thanks for your response i already have enough space on C = 77 G and my package = 106 M i alreday tried your solution but it was failed yesterday i installed the SharePoint again but as a standard to try and tried to restore the package but i recieved the same message the site collection couldn't be restored. if the problem persists please make sure the content databases are available and have sufficient free space

"i alreday tried your solution but it was failed" what method are your talking? the attach database to you SQL server then use "stsadm -o addcontentdb" to add Database to sharepoint? what error give you? Another thing verify if you have the exact sharePoint version on both sides. Is not recomend use the "stsadm -o backup" on databases bigger then 15 gigabytes. http://technet.microsoft.com/en-us/library/cc263441(office.12).aspx André Lage Microsoft SharePoint, CRM and Sybase Consultant Blog:http://aaclage.blogspot.com Codeplex:http://spupload.codeplex.com/http://simplecamlsearch.codeplex.com/