开发者

Check SQL Database offline

I am trying to check the integrity of MSSQL database when microsoft SQLServer itself not r开发者_开发技巧unning (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


Almost by definition the only thing that can check a SQL Server database is... SQL Server.

So you will definitely need to have an instance available that you can use to check the files. Something like the (free) SQL Server Express should do the job if your database files are not too large, as you won't be running with lots of users.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜