Jesoba.com is launched, Click below image to access it

Jesoba.com is launched, Click below image to access it
Technology and Entertainment Blog

Error 9003 when attaching SharePoint database

Error 9003 when attaching SharePoint database.

We get following error when we try to attach SharePoint content database, it is difficult to know what this error means.

The LSN (9764:53:1) passed to log scan in database 'STS_RECUPEROSVR01_1' is invalid.
Could not open new database 'STS_RECUPEROSVR01_1'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 9003)

Solution :

- Create a new db with same SharePoint database name.
- Now replace mdf, ldf with actual files.
- Now you would see that database would go in suspect mode.
- Run following rebuild command.

 DBCC REBUILD_LOG('STS_RECUPEROSVR01_1', 'C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data\STS_RECUPEROSVR01_1_log.LDF')

No comments:

Google+ Badge

About Author

My photo

I am Senior Server Expert and Professional Blogger.