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')
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:
Post a Comment