SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 System database checksum file has invalid signatur
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

digger00000007
Starting Member

2 Posts

Posted - 11/23/2011 :  18:03:15  Show Profile  Reply with Quote
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

USA
37157 Posts

Posted - 11/23/2011 :  19:34:34  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 11/24/2011 :  05:53:30  Show Profile  Reply with Quote
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

USA
37157 Posts

Posted - 11/24/2011 :  17:45:14  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000