Friday, February 17, 2012

DB in suspect mode

Hi,
one of databases came up in suspect mode (due to a
hardware IO error). I'm not sure what files did it have.
Is there any way to find out what files (and paths) that
database had?
Thanks,
OJ
Have a look at the sysaltfiles table in the master database.
Andrew J. Kelly SQL MVP
"OJ" <anonymous@.discussions.microsoft.com> wrote in message
news:19ff01c4dd6e$1c1de9c0$a501280a@.phx.gbl...
> Hi,
> one of databases came up in suspect mode (due to a
> hardware IO error). I'm not sure what files did it have.
> Is there any way to find out what files (and paths) that
> database had?
> Thanks,
> OJ

No comments:

Post a Comment