Prev: Permission issue with LINQ ?
Next: Combine Query
From: Roy Goldhammer on 4 Aug 2010 04:39
Hello there

In some database there were corruption who cause it to be down.

the Only backup i have is the mdf 6 hours before corruption.

the file was conneted to database when the disk backup occur.

How can i revive it?


From: Erland Sommarskog on 4 Aug 2010 16:02
Roy Goldhammer (royg(a)yahoo.com) writes:
> In some database there were corruption who cause it to be down.
>
> the Only backup i have is the mdf 6 hours before corruption.
>
> the file was conneted to database when the disk backup occur.
>
> How can i revive it?

So you don't have a proper backup taken through SQL Server, but
only a file-system backup of the MDF file only?

In such case, your prospects are not very good. I would recommend that
you open a case with Microsoft, since assisting with disaster recovery
in a newsgroup is a bit risky when you don't see the full picture.

--
Erland Sommarskog, SQL Server MVP, esquel(a)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
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: Permission issue with LINQ ?
Next: Combine Query