HTTP 400 Bad Request in WSS 3.0
Hi, I have a site in my Windows Sharepoint 3.0 and today my server was hang, after I do a hardreset, I can´t access to our WSS site, the explorer show HTTP 400 Bad Request.
I don´t have a backup, but I can see the Content Database with the SQL Management Studio.
I already create a new site and restore the ContentDatabase with the overwrite option, but the problem persist (HTTP 400).(I restore using the SQL Management Studio 2005).
Is there a way to restore my site from the WSS_Content database?
Regards!
I don´t have a backup, but I can see the Content Database with the SQL Management Studio.
I already create a new site and restore the ContentDatabase with the overwrite option, but the problem persist (HTTP 400).(I restore using the SQL Management Studio 2005).
Is there a way to restore my site from the WSS_Content database?
Regards!
ASKER
Hi,
Where I can see the Sharepoints logs?
I don´t have any event regarding the problem on Event Viewer.
Thanks
Where I can see the Sharepoints logs?
I don´t have any event regarding the problem on Event Viewer.
Thanks
ASKER
Dear Nalla,
I perform the following:
1. Restore the DB "WSS_Content" using the SQL Management Studio
2. Create a new application called http://server02:4444 without any site, only the app.
3. Run "stsadm -o addcontentdb -url http://server02:4444 -databasename WSS_Content"
Now in the WSS admin page I can view the DB "WSS_Content" is already associated in the new app, and also another DB content created by the system, and both show "zero sites created" and the state is "running"
The answer now,
How I can "re-create" my site with the information?
Regards!!
I perform the following:
1. Restore the DB "WSS_Content" using the SQL Management Studio
2. Create a new application called http://server02:4444 without any site, only the app.
3. Run "stsadm -o addcontentdb -url http://server02:4444 -databasename WSS_Content"
Now in the WSS admin page I can view the DB "WSS_Content" is already associated in the new app, and also another DB content created by the system, and both show "zero sites created" and the state is "running"
The answer now,
How I can "re-create" my site with the information?
Regards!!
take following steps
1. Create Web App on new Server
Central Admin->Application Management->Create or extend Web App->Create New Web App.
2. Associate restored DB with new Web App
Central Admin->Application Management->SharePoint Web Application Management->Content Databases->Remove Content Database from your new web app.
3. Now use STSADM to add restored DB to this web app
c:\program files\common files\microsoft shared\web server extentions\12\bin on new server is where you can find the STSADM.
run this command from there.
stsadm -o addcontentdb -url http://yourwebapp:port -databasename yourcontentdb -databaseserver yoursqlserver
4. Run ISSRESET from command prompt.
Note:
1. make sure your running the same service pack level on both source and destination sharepoint if possible.
2. Make sure you install all webparts, solutions, features, etc on new server before you restore the content database, so that it can find all the features it's looking for.
3. Make sure you copy any files that may be living in the file system that you need, sometimes people have css/javascript here. (This refers to files in the hive)
4. Leave your old site and contentDB intact until you get the backup running on the new server, this way your ok if there is a problem.
5. DON'T try this with your config database! It won't work!
hope this will help you to recreate your site.
1. Create Web App on new Server
Central Admin->Application Management->Create or extend Web App->Create New Web App.
2. Associate restored DB with new Web App
Central Admin->Application Management->SharePoint Web Application Management->Content Databases->Remove Content Database from your new web app.
3. Now use STSADM to add restored DB to this web app
c:\program files\common files\microsoft shared\web server extentions\12\bin on new server is where you can find the STSADM.
run this command from there.
stsadm -o addcontentdb -url http://yourwebapp:port -databasename yourcontentdb -databaseserver yoursqlserver
4. Run ISSRESET from command prompt.
Note:
1. make sure your running the same service pack level on both source and destination sharepoint if possible.
2. Make sure you install all webparts, solutions, features, etc on new server before you restore the content database, so that it can find all the features it's looking for.
3. Make sure you copy any files that may be living in the file system that you need, sometimes people have css/javascript here. (This refers to files in the hive)
4. Leave your old site and contentDB intact until you get the backup running on the new server, this way your ok if there is a problem.
5. DON'T try this with your config database! It won't work!
hope this will help you to recreate your site.
ASKER
Hi I already perform the operation, the DB is attached, but there is not any site collection.
The admin page show "0" zero sites
:(
The admin page show "0" zero sites
:(
ASKER
I install a clean WSS 3.0 installations in another server with a SQL 2005 SP3, but the problem is the same, I can attatch de DB, but can´t access to site collection.
Another info: the source server is a SBS2003 with WSS 3.0 and later I apply the SP2.
and the new server is WSS 3.0 with SP2 included.
Regards,
Another info: the source server is a SBS2003 with WSS 3.0 and later I apply the SP2.
and the new server is WSS 3.0 with SP2 included.
Regards,
does current db was linked with any other web application also? is so .. then just remove it from there and try again
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SharePoint logs
Event viewer