Check SQL Database offline

• yerram.santhosh

  SSC Enthusiast

  Points: 132

  More actions

  December 15, 2009 at 3:40 am

  #135999

  I am trying to check the integrity of MSSQL database when microsoft SQLServer itself not running (or) is not installed . Means i have mdf and ldf files of one database how can i check integrity( like DBCC CHECKDB when database is online on sqlserver).

  Thanks in advance

• Adi Cohn-120898

  SSC-Dedicated

  Points: 33944

  More actions

  December 15, 2009 at 3:51 am

  #1092416

  No you can’t. You have to use an instance of SQL Server in order to work with the databases.

  Adi

  --------------------------------------------------------------
  To know how to ask questions and increase the chances of getting asnwers:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/