Tuesday, March 27, 2012
Error When SQL 7.0 starts. Please Help.
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...