-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 9:17 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue
http://www.tek-tips.com/gfaqs.cfm/pid/962/fid/4210
http://www.mssqlcity.com/FAQ/Trouble/SuspectDB.htm
try these?
-----Original Message-----
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 10:10 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue
Unfortunately the last back up I had was from 11/28. This all happened
yesterday. And yes the .ldf file was deleted.
-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 9:10 AM
To: CF-Talk
Subject: RE: OT-SQL Data file issue
you deleted the ldb file?
uhhh, hmm, do you have a backup?
tw
-----Original Message-----
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 10:06 AM
To: CF-Talk
Subject: OT-SQL Data file issue
Ok I made a big mistake. I had a database set to FULL thinking it was set to
SIMPLE and forgot to set up a job to truncate the transaction log. Needless
to say, the transaction log grew huge (14g) and sucked up all my memory. So
I took the database offline and deleted the file and replaced it with a new
empty one. Well that made my database suspect. How can I fix this?
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
