HI,

For some reason, my SQL Server 6.5 will not restart. I tried the obvious starting, stopping and rebooting, but to no avail. It just will not start. I tried using the SQLSERVR command line and got the following interesting messages at the end. Obviously something is messed up badly, but how do I recover? If I can restart...then I can recover hopefully.

Any ideas?

...
99/02/08 18:46:24.06 spid10 Recovering database 'SalesMartSnaps'
99/02/08 18:46:24.06 spid10 Recovery dbid 19 ckpt (46351,27) oldest tran=(46351,0)
99/02/08 18:46:24.12 kernel udread: Operating system error 38(Reached end of file.) on device 'FATASQL65MASTER.DAT' (virtpage 0x00ffff00).
99/02/08 18:46:24.14 spid11 OS Error 38(Reached end of file.) on device 'FATASQL65MASTER.DAT' during bufget
99/02/08 18:46:24.14 spid11 Buffer eca300 from database 'SalesMart' has page number 0 in the page header and page number -256 in the buffer header
99/02/08 18:46:24.14 spid11 Error while undoing log row in database 'SalesMart'. Rid pageid is 0x3708c1 and row num is 0x1d.
99/02/08 18:46:24.14 spid11 Error : 3414, Severity: 21, State: 1
99/02/08 18:46:24.14 spid11 Database 'SalesMart' (dbid 6): Recovery failed. Please contact Technical Support for further instructions.
99/02/08 18:46:24.14 spid1 Recovery complete.
99/02/08 18:46:24.14 kernel udread: Operating system error 6(The handle is invalid.) on device 'FATASQL65MASTER.DAT' (virtpage 0x00000294).
99/02/08 18:46:24.14 kernel udread: Operating system error 6(The handle is invalid.) on device 'FATASQL65MASTER.DAT' (virtpage 0x00000394).


Thanks,
Perry Tohn