Discussion:
Sql Database Recovery
(too old to reply)
inter
2006-10-27 18:49:31 UTC
Permalink
Can not attach database,

Error message;

The file you've specified is not a valid SQL Server database file.

mybe Database some corrupt.
Arnie Rowland
2006-10-27 19:07:47 UTC
Permalink
If "Database some corrupt", then you may not be able to attach it -the file
is either not a SQL Server database file or it is corrupt.

You need to use your backup. (You do have backup, don't you?)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
Post by inter
Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.
mybe Database some corrupt.
inter
2006-10-27 19:13:32 UTC
Permalink
I don't have some backup.
But, some recovery file
(http://www.surfpack.com/downloads/Recovery-for-SQL-Server/15407.html)
recovered my database only some table's.
Post by Arnie Rowland
If "Database some corrupt", then you may not be able to attach it -the
file is either not a SQL Server database file or it is corrupt.
You need to use your backup. (You do have backup, don't you?)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to
the top yourself.
- H. Norman Schwarzkopf
Post by inter
Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.
mybe Database some corrupt.
inter
2006-10-27 19:18:25 UTC
Permalink
My costumer HDD some files Deleted mybe elektric prblem -Elektrik
go,com,go,come- then windows not opened.
insert corrupt hdd Another computer, then recovering (recover my files
software)
Recover mdf and ldf files. but not attach,
Post by Arnie Rowland
If "Database some corrupt", then you may not be able to attach it -the
file is either not a SQL Server database file or it is corrupt.
You need to use your backup. (You do have backup, don't you?)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to
the top yourself.
- H. Norman Schwarzkopf
Post by inter
Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.
mybe Database some corrupt.
Arnie Rowland
2006-10-27 19:43:40 UTC
Permalink
That doesn't sound very good, nor does it sound very hopeful to recover the
'lost' data.

You may wish to contact PSS and open a ticket. They 'may' be able to help
you.

See: http://support.microsoft.com/default.aspx?scid=fh;EN-US;offerprophone
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
Post by inter
My costumer HDD some files Deleted mybe elektric prblem -Elektrik
go,com,go,come- then windows not opened.
insert corrupt hdd Another computer, then recovering (recover my files
software)
Recover mdf and ldf files. but not attach,
Post by Arnie Rowland
If "Database some corrupt", then you may not be able to attach it -the
file is either not a SQL Server database file or it is corrupt.
You need to use your backup. (You do have backup, don't you?)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to
the top yourself.
- H. Norman Schwarzkopf
Post by inter
Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.
mybe Database some corrupt.
inter
2006-10-29 23:20:52 UTC
Permalink
I can not repair my problem Pleace help me.
I am recovery .mdf file http://www.officerecovery.com/mssql/ some table ok.
but my importand table is not ok.

if I can recover another recovery software , my database correct recover or
same.?
I am using RecoverMyFiles.
Post by Arnie Rowland
That doesn't sound very good, nor does it sound very hopeful to recover
the 'lost' data.
You may wish to contact PSS and open a ticket. They 'may' be able to help
you.
See: http://support.microsoft.com/default.aspx?scid=fh;EN-US;offerprophone
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to
the top yourself.
- H. Norman Schwarzkopf
Post by inter
My costumer HDD some files Deleted mybe elektric prblem -Elektrik
go,com,go,come- then windows not opened.
insert corrupt hdd Another computer, then recovering (recover my files
software)
Recover mdf and ldf files. but not attach,
Post by Arnie Rowland
If "Database some corrupt", then you may not be able to attach it -the
file is either not a SQL Server database file or it is corrupt.
You need to use your backup. (You do have backup, don't you?)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to
the top yourself.
- H. Norman Schwarzkopf
Post by inter
Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.
mybe Database some corrupt.
Greg D. Moore (Strider)
2006-10-31 05:27:23 UTC
Permalink
Post by inter
I can not repair my problem Pleace help me.
I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
ok. but my importand table is not ok.
if I can recover another recovery software , my database correct recover
or same.?
I am using RecoverMyFiles.
As said, contact Microsoft.

One other option is to contact someone like ontrack.com, give them your
credit card number and hope for the best.


Seriously it's unlikely you'll get back a consistent database though.

Sorry.
Post by inter
Post by Arnie Rowland
That doesn't sound very good, nor does it sound very hopeful to recover
the 'lost' data.
You may wish to contact PSS and open a ticket. They 'may' be able to help
you.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;offerprophone
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to
the top yourself.
- H. Norman Schwarzkopf
Post by inter
My costumer HDD some files Deleted mybe elektric prblem -Elektrik
go,com,go,come- then windows not opened.
insert corrupt hdd Another computer, then recovering (recover my files
software)
Recover mdf and ldf files. but not attach,
Post by Arnie Rowland
If "Database some corrupt", then you may not be able to attach it -the
file is either not a SQL Server database file or it is corrupt.
You need to use your backup. (You do have backup, don't you?)
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to
the top yourself.
- H. Norman Schwarzkopf
Post by inter
Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.
mybe Database some corrupt.
j***@gmail.com
2012-07-11 09:21:25 UTC
Permalink
Post by inter
Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.
mybe Database some corrupt.
Kernel for SQL recovery is an amazing tool that fixes all errors of corrupt or inaccessible SQL database files. Its powerful search engine retrieves every bit of data from the corrupt MDF files and save the retrieved information in new MDF files. Using this recovery program, you can repair large number of inaccessible MDF files with a single mouse click. The kernel for SQL database recovery tool reinstates all forms of data like triggers, tables, indexes, stored procedures, unique keys and foreign keys from the corrupt SQL database folders. To know more about tool visit http://www.restoresqldatabase.org/
Erland Sommarskog
2012-07-11 11:15:53 UTC
Permalink
Post by j***@gmail.com
Kernel for SQL recovery is an amazing tool that fixes all errors of
corrupt or inaccessible SQL database files. Its powerful search engine
retrieves every bit of data from the corrupt MDF files and save the
retrieved information in new MDF files. Using this recovery program, you
can repair large number of inaccessible MDF files with a single mouse
click. The kernel for SQL database recovery tool reinstates all forms of
data like triggers, tables, indexes, stored procedures, unique keys and
foreign keys from the corrupt SQL database folders. To know more about
tool visit http://www.restoresqldatabase.org/
I am not going to question that the tool you are trying to peddle can
recover *some* corrupt databases, but when you say "all errors", I can
tell that you are lying through your teeth. If the I/O subsystem decided
to write all zeroes in a disk block, then you can forget about recovering
the information in that disk block.

More generally, a database file may be corrupt in a multitude of ways,
and writing a tool that handle all sorts of corruption is not really
possible. In many cases, you might be able to retrieve data from a
crashed MDF file if you know the table definition and/or has some
knowledge about the data. For instance, a human may recognise that
a certain id is in fact the id for an important customer, something
a piece of software will not be able to.

I post these words in case someone with a crashed database and for a
moment think you have found the golden key.
--
Erland Sommarskog, SQL Server MVP, ***@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
t***@gmail.com
2013-05-17 21:41:03 UTC
Permalink
Perform sql databases recovery by using of how to fix corrupted database in sql server

Article http://www.mssqlserver2008fix.fixsqldatabase.com is able to rescue the situation
r***@gmail.com
2015-08-06 10:20:26 UTC
Permalink
There are several other software also available for SQL Recovery, I would also like to mention here one of them. By this effective application, you can instantly repair damaged MDF file with in few clicks. You can get more details along with a free trial from here :- http://www.sql.recoverydeletedfiles.com/
Loading...