Post reply

How to test integrity of a database in sql server?

  • February 24, 2007 at 7:39 am

    #369618

    Hi,

    I just wanted to know how I have to perform an integrity test and get status of a database in Sql Server?

    Thanx for ur response in advance.

  • February 25, 2007 at 11:29 pm

    #691653

    Try the following....

    DBCC

    CHECKDB ('dbname') WITH tableresults

     

    MohammedU
    Microsoft SQL Server MVP

  • March 12, 2007 at 1:03 am

    #694300

    Thank MohammedU.

    I found a section where I can check integrity of the database in the maintenance section of sql server. But I still want to use the command u gave me. However I dont know where I can write that command. Can u help me on that?

    One more thing how sever do u think are the errors identified using this command?

    Regards,

    SL

  • March 12, 2007 at 5:37 am

    #694324

    Just open a new query window in SQL Server Management Studio and execute the command. Easiest way is to type it in, select all the text and then hit F5.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply