Hi, I am using MOSS 2007 with project server. Last year, we changed the name of our database server using rename server command. After that the Central Admin and web application were working fine but last week after installing the patches when I ran CA/web application, it is giving me HTTP/1.1 404 Connection: close Date: Wed, 28 Jul 2010 13:33:12 GMT Server: Microsoft-IIS/6.0 MicrosoftSharePointTeamServices: 12.0.0.6219 X-Powered-By: ASP.NET. In the event viewer, I m getting Error 3351 : "SQL database login failed. Additional error information from SQL Server is included below. Login failed for user 'domain\username'” I checked the registry of the server and noticed that the SSO database is still pointing to the old database server while all other databases are pointing to the new database server. As we have only one site running on this server, I need to restore it. Is there any way to restore only one document library? Can anyone please provide me the detail steps for restoring the site? Thanks, Patav

Hi patav, You can use Microsoft System Center Data Protection Manager 2007 (DPM) to easily recover a list or document library. For the detailed steps, you can refer to the following article: http://technet.microsoft.com/en-us/library/cc424962(office.12).aspx If the resolution can’t help you, you can consider the following method: How to recover SharePoint document once deleted from recycle bin http://blogs.msdn.com/b/modonovan/archive/2007/09/14/how-to-recover-sharepoint-document-once-deleted-from-recycle-bin.aspx Regards, Rock Wang Microsoft Online Community Support

Hi Rock, Thanks for your reply. FYI.... I am not able to access Central Admin Site as well as Web application. But I have a list of all the databases which have been used at the time of MOSS installation. So is there any way to restore my site from the content database? Can you please provide me the steps for this process? Thanks, Patav.

Hi Just use the following command in all the servers except Database stsadm -o upgrade -forceupgrade -inplace This will work.

Hi ||anez||, Thanks for ur reply. When I tried to run this command, it is giving me below error: Login failed for user 'domain\username'. Also in the event viewer, I am getting 3351 error. I also checked on the database server that SharePoint Service Account (domain\username) already has dbcreator and Securityadmin roles. Patav