Showing posts with label starts. Show all posts
Showing posts with label starts. Show all posts

Tuesday, March 27, 2012

Error When SQL 7.0 starts. Please Help.

This is what the error log says.

2003-08-12 14:09:53.49 server Copyright (C) 1988-2000 Microsoft Corporation.
2003-08-12 14:09:53.49 server All rights reserved.
2003-08-12 14:09:53.49 server Server Process ID is 418.
2003-08-12 14:09:53.49 server Logging SQL Server messages in file 'd:\data\MSSQL\log\ERRORLOG'.
2003-08-12 14:09:53.50 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2003-08-12 14:09:53.55 server SQL Server configured for thread mode processing.
2003-08-12 14:09:53.55 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2003-08-12 14:09:53.60 server Attempting to initialize Distributed Transaction Coordinator.
2003-08-12 14:09:54.63 spid2 Starting up database 'master'.
2003-08-12 14:09:54.74 server Using 'SSNETLIB.DLL' version '8.0.534'.
2003-08-12 14:09:54.74 spid5 Starting up database 'model'.
2003-08-12 14:09:54.75 spid2 Server name is 'OPTICAL1'.
2003-08-12 14:09:54.75 spid9 Starting up database 'pubs'.
2003-08-12 14:09:54.75 spid8 Starting up database 'msdb'.
2003-08-12 14:09:54.75 spid10 Starting up database 'Northwind'.
2003-08-12 14:09:54.77 spid11 Starting up database 'otg'.
2003-08-12 14:09:54.77 server SQL server listening on 172.16.16.37: 1433.
2003-08-12 14:09:54.77 server SQL server listening on 127.0.0.1: 1433.
2003-08-12 14:09:54.78 server SQL server listening on TCP, Shared Memory, Named Pipes.
2003-08-12 14:09:54.78 server SQL Server is ready for client connections
2003-08-12 14:09:54.78 spid5 Error: 9003, Severity: 20, State: 1
2003-08-12 14:09:54.78 spid5 The LSN (4:396:1) passed to log scan in database 'model' is invalid..When this happens, the MSSQLSERVER Service fails to start. :(|||I copied the Model Database from the CD into the Data directory, and restarted the service.sql

Wednesday, March 7, 2012

Error using Verify/Repair methods of SqlCeEngine

I have a compact pc program that uses a sql server database (sdf file).
I want to check the database integrity when program starts so I added a call to veriy method of SqlCeEngine.

The verify function always returns false even the database is OK and I can work with it.

when I call repair it throws the exception : "The specified module could not be found"

The code is :

string connectionString = "Data Source = '" + m_dbFullName + "'";

SqlCeEngine engine = new SqlCeEngine(connectionString);

if(engine.Verify() == false)

{

engine.Repair(null, RepairOption.RecoverCorruptedRows);

}

The database exists and the path to it is correct:

dbFullName = "\\program files\\MyApp\\MyDB.sdf"

I also tried out some different connection strings but it did not help:

"Data Source = ' MyDB.sdf '"

"Data Source = 'MyDB.sdf "

"Data Source=' MyDB.sdf '"

"Data Source=MyDB.sdf"

Please any one can help me with this ?

I have the same problem...