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
 General SQL Server Forums
 Data Corruption Issues
 Recovering a SQL Server 6.0 Database from a Corrup

Author  Topic 

belmonte364
Starting Member

1 Post

Posted - 2014-11-28 : 11:23:49

I've searched around and to no avail have found a solution.
My situation is:
-Working SQL server directory was deleted, no backups of said directory or full database backups (oh joy!),
-Recovered the .mdf files via file recovery software. They appear to be in tact but so far I've had no luck with a few .mdf recovery programs,
-It's imperative that all avenues of recovery are attempted to get the data back (even if that requires $$$$$$$).

Do you have any advice? Has anyone been in this situation before?
Thanks.

bergvist37
Starting Member

1 Post

Posted - 2014-12-01 : 09:39:32
Hi! Try to find something to fix this problem here:
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/569-i-have-a-problem-how-do-i-fix-a-corrupted-database-file
• Click the Windows \"Start\" button and select \"All Programs.\" Click your \"SQL Server\" program group and click the \"SQL Server Management Studio\" shortcut. This opens the Management Studio console application.
• Click the SQL Server name on the left side of your console. In the main toolbar, click \"New Query.\" This opens a query window where you execute the \"sp_attach_db\" stored procedure.
• Type the following command into your query console:
sp_attach_db 'Database_Name','c:\backupDB.mdf','C:\backupLogs.ldf'
• The first parameter is the \"Database_Name.\" This is the name of the database that registers with SQL Server. This can be the original name of the backed up database, or you can give it a new name. The second parameter is the location and file name for the MDF file. The third is the location for the LDF file. You can restore from the local hard drive, an external drive or a shared network location.
• Press the \"F5\" key. This executes the SQL statement and restores the database along with the log file.
Or get 100% paid solution here: SQL Server Fix Toolbox http://www.fixsqldatabase.com/
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-01 : 11:44:11
I'm confused what version you are using. The mdf extension wasn't used in SQL Server 6.0. I believe it was .dat.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -