Wednesday, March 21, 2012

database showing suspect

I moved a database file (.mdf) from the Microsoft SQL Server data directory to another location, and moved it back into the original location. After which the database staus changed to suspect.
How do I make it live? ThanksRead up on sp_resetstatus in the Books online.

No comments:

Post a Comment