Home > SSIS > Check your database integrity using SSIS

Check your database integrity using SSIS


First of all, Happy Memorial day 🙂

We often prefer to check the integrity of the SQL Server Database objects. Check Database integrity task does check the allocation and structural integrity of all the objects in the specified database(s).

It is single command that check for Allocation, table, catalog and etc…

This task is equal to DBCC CHECKDB() T-SQL command. It performs following actions when we fire CHECKDB()  command on the SQL Server.

  1. It runs CHECKALLOC on the database.
  2. It runs CHECKTABLE on every table and view in the database.
  3. It runs CHECKCATALOG on the database.
  4. It validates the contents of every indexed view in the database. We can select database indexes to check the integrity using this task by checking include indexes.
  5. It validates link-level consistency between table metadata and file system directories and files when storing varbinary(max) data in the file system using FILESTREAM.
  6. It validates the Service Broker data in the database.

For more information read http://msdn.microsoft.com/en-us/library/ms176064.aspx

Implementation

Step 1: Create a package and add check database integrity task from the tool box under database maintenance plan tasks.

Step 2: Create database instance connection by clicking new button and give the name of the connection

Step 3: Select the databases from the list to perform database integrity check. We can also eliminate the databases which are offline when firing this command at runtime. Please select the checkbox if needed.

Step 4: Select “include indexes” option if need. Otherwise, deselect the check box.

Step 5: Click the view T-SQL button to see the T-SQL statement.

Step 6: Click ok and execute the package.

Thanks for reading this article and see more in upcoming posts 🙂

Advertisements
  1. August 14, 2014 at 1:22 pm

    I know this web site gives quality depending
    articles or reviews and additional material, is there any other web site which offers such information in quality?

    • August 16, 2014 at 2:02 pm

      Should be available out there in the internet. I often use http://msdn.microsoft.com/en-us/ for Microsoft products.

      It also depends on your needs. Because, we cannot point any single website to say it is the best. So, we need to search for the better quality content from various sites.

      what is your search about?

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: