Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 System database checksum file has invalid signatur

Author  Topic 

digger00000007
Starting Member

2 Posts

Posted - 2011-11-23 : 18:03:15
Hello.

I'm currently trying to get a instance of sharepoint up and running after a server recovery. All the files have been restored including permissions. The MSSQL$SHAREPOINT service starts and then stops straight away. The error log looks like this

2011-11-23 22:07:12.15 server Microsoft SQL Server 2000 - 8.00.2055 (Intel X86)
Dec 16 2008 19:46:53
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine (Windows) on Windows NT 5.2 (Build 3790: Service Pack 2)

2011-11-23 22:07:12.16 server Copyright (C) 1988-2002 Microsoft Corporation.
2011-11-23 22:07:12.18 server All rights reserved.
2011-11-23 22:07:12.18 server Server Process ID is 7544.
2011-11-23 22:07:12.18 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\LOG\ERRORLOG'.
2011-11-23 22:07:12.21 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2011-11-23 22:07:12.37 server SQL Server configured for thread mode processing.
2011-11-23 22:07:12.37 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2011-11-23 22:07:12.44 spid4 Starting up database 'master'.
2011-11-23 22:07:12.57 spid4 1 transactions rolled back in database 'master' (1).
2011-11-23 22:07:12.57 spid4 Recovery is checkpointing database 'master' (1)
2011-11-23 22:07:12.69 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2011-11-23 22:07:12.69 spid5 Starting up database 'model'.
2011-11-23 22:07:12.71 spid4 Server name is 'INTEGRITY\SHAREPOINT'.
2011-11-23 22:07:12.74 spid8 Starting up database 'msdb'.
2011-11-23 22:07:12.76 spid9 Starting up database 'STS_Config'.
2011-11-23 22:07:12.76 server SQL server listening on Shared Memory.
2011-11-23 22:07:12.76 server SQL Server is ready for client connections
2011-11-23 22:07:12.76 spid10 Starting up database 'STS_INTEGRITY_1'.
2011-11-23 22:07:12.98 spid8 1 transactions rolled back in database 'msdb' (4).
2011-11-23 22:07:12.99 spid10 1 transactions rolled back in database 'STS_INTEGRITY_1' (6).
2011-11-23 22:07:13.01 spid10 Recovery is checkpointing database 'STS_INTEGRITY_1' (6)
2011-11-23 22:07:13.01 spid9 1 transactions rolled back in database 'STS_Config' (5).
2011-11-23 22:07:13.02 spid5 1 transactions rolled back in database 'model' (3).
2011-11-23 22:07:13.02 spid8 Recovery is checkpointing database 'msdb' (4)
2011-11-23 22:07:13.02 spid5 Recovery is checkpointing database 'model' (3)
2011-11-23 22:07:13.02 spid9 Recovery is checkpointing database 'STS_Config' (5)
2011-11-23 22:07:13.34 spid5 Clearing tempdb database.
2011-11-23 22:07:14.46 spid5 Starting up database 'tempdb'.
2011-11-23 22:07:15.07 spid4 Recovery complete.
2011-11-23 22:07:15.12 spid4 System database checksum file has invalid signature.

I've searched around the internet and cant find any solution. I have tried restoring the files in C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data with no luck. It is an SBS server and there are other databases running, so I don't want to restore the other folders as those DB's are starting and running.

Any help or suggestions would be greatly appreciated!

Thanks
James

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-11-23 : 19:34:34
Restoring files isn't how you restore SQL. You need to restore from SQL Server backups. Do you have SQL Server backups? I don't mean backups of files, but rather backups of databases.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

digger00000007
Starting Member

2 Posts

Posted - 2011-11-24 : 05:53:30
I'm thinking this is probably the reason why the database isn't working. We only have windows backup files and not a SQL backup. Is there anyway we can get the database online with the files from a windows backup?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-11-24 : 17:45:14
Probably not as the files are usually not good if the SQL Server service was running at the time.

It is critical that SQL backups be performed. We don't even both with file backups of the SQL files, but we do sweep our SQL backups to tape.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -