I have detached one database from Sql server . I have database( .mdf and .ldf ) files with me. Now how can i read that database file. I want to validate that database is good or not. Means i want the similar to DBCC CHECKDB command to check the database with out attaching it to Sql server.
Is there any way or any FREE tool provided by microsoft .
Thanks in advance
asked Jan 20, 2010 at 02:37 AM in Default
If you're only using an instance of SQL Server for DR purposes (and not using it for production at all), then it doesn't need to be licensed. So the free tool you can use is another copy of SQL Server itself.
But you might have been better off taking a backup and restoring that. If a restored database successfully passes DBCC CHECKDB, then the original one must be fine too.
answered Jan 20, 2010 at 03:50 AM
A suggestion: Instead of de-taching it in the first place; do a backup of the database, and run RESTORE VERIFYONLY ... on the backup.
It does take up extra diskspace, but your database stays online all the time.
Henrik Staun Poulsen www.stovi.com
answered Jan 20, 2010 at 10:11 AM
Henrik Staun Poulsen
The best way is probably to bring it into a copy of SQL Server. If you need to verify it before it gets to a production machine, you can use a copy on test server. If it is smaller than 4 GB you can use SQL Server Express for free.
I am not aware of anything besides SQL Server that can do the equivalent of MDCC commands to a SQL Server file.
answered Jan 20, 2010 at 10:40 AM