What is database suspect mode ?

-
A database is always in a specific status such as online, offline, recovering, restoring, emergency, suspect, etc. 
Among them today we are going to discuss about suspect mode.
If a database go into suspect mode we cannot work on it or at least can’t connect to the database until it becomes online mode. The main reason for a suspect status is damaging the primary filegroup of the database. So to recover this issue we have to perform some specific actions.

What are the reasons to marks database as Suspect?

Hardware failure.
Database server is not shutdown properly.
Corruption of the database files.
Missing database logging files
Low disk spaces.
SQL cannot complete a rollback or roll forward operations.

Steps to recover the Suspect mode of database

Open SQL Server Management Studio.

Select New Query and we have to turn on emergency mode.by turn on the emergency mode it allows read only access to the administrator. We can do it by,
          ALTER DATABASE  dbName  SET  EMERGENCY

By changing the status then administrator can access it.then by DBCC CHECKDB we can check all logical and physical integrity of the specified database.
          DBCC CHECKDB('dbName')

If we any error by this execution we turn the database into single user mode and make changes.if there are no errors we no need to do the following execution.
          ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Then we can rerun the CHECKDB command as(note that executing the following command is really dangerous as it is one-way command.)
          DBCC CHECKDB [‘dbName’, REPAIR_ALLOW_DATA_LOSS]

At last again we can bring the database from single user mode to multi user mode.
          ALTER DATABASE dbName SET MULTI_USER

By following steps you can fix the suspect mode of the database. Refresh the database server and verify the connectivity. Then you can connect properly.

Running DBCC CHECKDB command regularly we can check the physical and logical integrity of the database.

x

Comments

Post a Comment

Popular posts from this blog

What is Rapid Application Development

-
Image
Rapid Application Development (RAD) is a software development life-cycle designed to give; much faster development and higher-quality results than those achieved with the traditional life-cycle High speed, High quality, low lost are the three main goals of rapid application development. We use RAD to Takes advantage of automated tools and techniques because it allows organizations to build software applications faster, better, and cheaper. RAD Model The process of writing the software itself involves the planning required for developing the product is known as Rapid Application Development Model. It consist main five phases. Business Modeling In here information flow among business functions is defined. That means the complete business analysis is done to understand the business. Business functions are defined by answering questions like what information drives the business process, what information is generated and who generated it, where does the info
Read more
-
Image
We all know operating systems are designed to help us in normal tasks which done by a compute such as Managing files, Loading programs, Printing documents etc. But developers are creating new programs to enhance or extend the operating system’s capabilities. Those are calls utility software. Simply utility programs provide new features which are not supported by an operating system. Now there are thousands of different utility software and we can find them on internet for free or with little price. Although we cannot take a definite list of utility software categories some common types are, Disk and file management programs Internet security Op customization tools Antivirus utilities A virus is a parasitic, scramble files or replicate itself until the host disk is full. Viruses can be transmitted in numerous ways such as while transforming files from one to another, downloading files over the internet or reusing old diskettes etc. So we use antiv
Read more

OOP Concepts

-
Image
today we are going to study about OOP concepts. Object oriented programming language is based on the concept of objects. Object oriented concepts are, Object Class Inheritance Polymorphism Encapsulation object an entity which has state(properties) and behavior is known as an object. it may be anything and may be logical or physical.Object is an instance of a class. ex :- dog,pen,tree,car,mother,...etc. as we told state and behavior let's discuss it with an example class class is a blue print or template of object. Which is a group of objects have similar properties. inheritance when one object acquires all or some properties of another object it is inheritance. That may the child will acquire their parents properties. as an example let's take the supper class as vehicle. A vehicle has colour,brand,speed,auto/manual etc. Car may be a sub class of above supper class. That means car has common properties in vehicle class and there may
Read more