Saturday, February 25, 2012

Missing Log - Suspect Datanbase - HELP!

A customer called me and said they ran the disk out of space, rebooted the
machine and the activity log is complaining about the database log being
already in use, and being out of disk. The database is in suspect mode, and
the database log is MIA!
Any ideas'
Thanks
RichardTry looking into system procs,
sp_add_data_file_recover_suspect_db and sp_add_log_file_recover_suspect_db
in books online
Thanks
"Richard Douglass" wrote:

> A customer called me and said they ran the disk out of space, rebooted the
> machine and the activity log is complaining about the database log being
> already in use, and being out of disk. The database is in suspect mode, a
nd
> the database log is MIA!
> Any ideas'
> Thanks
> Richard
>
>|||Richard
http://www.karaszi.com/SQLServer/in..._suspect_db.asp
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:OfDesPeVHHA.1000@.TK2MSFTNGP05.phx.gbl...
>A customer called me and said they ran the disk out of space, rebooted the
>machine and the activity log is complaining about the database log being
>already in use, and being out of disk. The database is in suspect mode,
>and the database log is MIA!
> Any ideas'
> Thanks
> Richard
>

No comments:

Post a Comment