MS SQL Server - A database file is demaged, no backup, anyway to fix it?

Author

A database file is demaged, no backup, anyway to fix it?

Frank Lee

2006-01-27, 8:23 pm

A database file (*.mdf) is demaged, no backup, anyway to fix it?

--frank, using sql2000

Tibor Karaszi

2006-01-28, 7:23 am

The only tool I know of is http://www.officerecovery.com/mssql/.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"Frank Lee" <Reply@to.newsgroup> wrote in message news:edAwrp6IGHA.208@tk2msftngp13.phx.gbl...
>A database file (*.mdf) is demaged, no backup, anyway to fix it?
>
> --frank, using sql2000
>
>

Michael Hotek

2006-01-31, 3:23 am

If that doesn't work, you can put the database in emergency mode and then
use DBCC PAGE to manually extract data. Very slow, very time consuming, and
no guarantees. I've only had to do it once and it wasn't very pretty.

--
Mike
http://www. solidqualitylearning
.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:%23CIeUI$IGHA.668@TK2MSFTNGP11.phx.gbl...[color=darkred]
> The only tool I know of is http://www.officerecovery.com/mssql/.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
> Blog: http:// solidqualitylearning
.com/blogs/tibor/
>
>
> "Frank Lee" <Reply@to.newsgroup> wrote in message
> news:edAwrp6IGHA.208@tk2msftngp13.phx.gbl...

Sponsored Links