MS SQL Server - Disk Full of transactions log's

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Disk Full of transactions log's

Richard@dt

2006-04-01, 7:23 am

Hi,

One of my app servers has filled the c:\ drive with transactions log's.
Someone moved the log's to another disk, SQL now reports the database as
being suspect. We moved the log's back, it still reports the db as suspect?

Any help would be greatly appreciated

Rich

Jens

2006-04-01, 11:23 am

Hi,

take a look here:

http://www.karaszi.com/SQLServer/ i...t
_db.asp

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

MSLam

2006-04-02, 8:23 pm

reset should resolve the problem (order in sequences, try the next step
if the first one doesn't work).

1) restart the MSSQL services (starts the auto recovery)

2) detach and re-attach the database

3) restore the latest database backup

Mel

Sponsored Links