Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Restoring data from unattachable MDF-file.

Author  Topic  Dankov Starting Member 1 Post Posted - 2002-10-25 : 06:21:01 New utility announcement MDF forced attacher utility for Microsoft SQL-server 7.0/2000 Link: http://forcedattach.nm.ru The product attaches alone MDF-file to Microsoft SQL-server and lets to get working database from it. ForcedAttach utility works with only MSSQL7.0 and MSSQL2000. The tool is intended to help to restore data contained within an alone MDF-file (the primary file of MSSQL database) in the two coplex cases: 1) You have only an alone MDF-file and you cannot attach the file with the help of "sp_attach_single_file_db" stored procedure. 2) A database has its status "suspect" and "sp_resetstatus" stored procedure doesn't help to correct it.