Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
 Posted - 2001-06-12 : 01:58:52
|
Yesterday as we were loading some data the server went head over heels. When it came back up one of my databases (26 GB) was marked as recovering. NO problem I thought. Until I looked a little later after giving it enough time to recover  2001-06-11 14:59:32.28 kernel SQL Server Assertion: File: , line=315 0Failed Assertion = 'm_len != 0'. 02001-06-11 14:59:32.38 spid8 Location: scanrid.cpp:315 0Expression: m_len != 0 0SPID: 8 0Process ID: 424 02001-06-11 14:59:32.77 spid8 Log space info for tran 0:28133058 in database 8 0 Before: LogRecs= 1173418 Used= 0, Rsvd= 0, SysUsed= 0 0 After: LogRecs= 1173625 Used= 11592, Rsvd= 0, SysUsed= 0 0 Short= 0, ShortComp= 11592, TotalUsed= 11592, Short%=100.0 02001-06-11 14:59:32.91 spid8 Error: 3314, Severity: 21, State: 3 02001-06-11 14:59:32.91 spid8 Error while undoing logged operation in database 'GFAS_MIS'. Error at log record ID (2781:141715:3).. 02001-06-11 15:12:55.30 spid8 Error: 3414, Severity: 21, State: 1 02001-06-11 15:12:55.30 spid8 Database 'GFAS_MIS' (database ID 8) could not recover. Contact Technical Support.  This is after a series of stack dump messagesThe database went to suspect status.The business wanted the database back quickly so I had a disk backup and kicked that off.  Local Disk to Local Server executed on the local machine. After 12 hours I only have 65% completed.  This server has beencrapping out every day for the people who use it as an FTP dropzone.Any ideas?Rick |
|
|
|
|
|
Corrupt Database