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.
| 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/ |
 |
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Recovering a SQL Server 6.0 Database from a Corrup