Server MSDE2K don't START.

[ALESSANDRO Baraldi]

Hi...and good morning.

I'm problem with AutoStart of my MSDE Server, i look in errorlog:

2003-10-24 12:33:53.25 spid5 Encountered an unexpected error while
checking the sector size for file 'C:\Programmi\Microsoft SQL
Server\MSSQL\Data\tempdb.mdf'. Check the SQL Server error log for more
information.
2003-10-24 12:33:53.29 spid5 Error: 823, Severity: 24, State: 6
2003-10-24 12:33:53.29 spid5 I/O error 38(Fine del file.) detected
during read at offset 0000000000000000 in file 'C:\Programmi\Microsoft SQL
Server\MSSQL\Data\tempdb.mdf'..
2003-10-24 12:33:53.32 spid5 WARNING: problem activating all tempdb
files. See previous errors. Restart server with -f to correct the
situation.

How can i do it: "Restart server with -f to correct the situation"

I don't know, but all my truble has been started when i rename the HD Label
and VirtualMemory size.

Thanks.

@Alex.

[Simon Hayes]

"ALESSANDRO Baraldi" <ik****@libero.it> wrote in message
news:bn**********@lacerta.tiscalinet.it...

Hi...and good morning.

I'm problem with AutoStart of my MSDE Server, i look in errorlog:

2003-10-24 12:33:53.25 spid5 Encountered an unexpected error while
checking the sector size for file 'C:\Programmi\Microsoft SQL
Server\MSSQL\Data\tempdb.mdf'. Check the SQL Server error log for more
information.
2003-10-24 12:33:53.29 spid5 Error: 823, Severity: 24, State: 6
2003-10-24 12:33:53.29 spid5 I/O error 38(Fine del file.) detected
during read at offset 0000000000000000 in file 'C:\Programmi\Microsoft SQL
Server\MSSQL\Data\tempdb.mdf'..
2003-10-24 12:33:53.32 spid5 WARNING: problem activating all tempdb
files. See previous errors. Restart server with -f to correct the
situation.

How can i do it: "Restart server with -f to correct the situation"

I don't know, but all my truble has been started when i rename the HD Label and VirtualMemory size.

Thanks.

@Alex.

http://support.microsoft.com/default...&Product=sql2k

Simon