March 19, 2013 at 12:17 pm
Hi Frineds,
What are the chances to get a DB offline or Suspect mode?
give me some examples please
Thank you in Advance
March 19, 2013 at 12:24 pm
A database goes offline when someone runs ALTER DATABASE <database name> SET OFFLINE or right clicks the database Tasks -> Set offline. That's a user operation. If you have a database that keeps going offline, speak to your colleagues and find out who's doing it.
A database goes suspect when corruption is encountered during the rollback of a transaction or during the restart recovery process. It means your database is damaged and that you need to find and restore your last good backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy