Monday, March 26, 2012

Recovery data from file mdf e log

from PC is uninstalled SQLSERVER2000 and related files mdf and log without to
execute backup database. With a tool of recovery file deleted *.mdf and
*.log, we have recoverd files. How to do you to recovery the database from
mdf e log file?
If you are lucky, you can attach them using sp_attach_db. This might not work, though as you didn't
detach the database first. If it doesn't work, open a case with MS Support and see if they can
assist.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"marisa" <marisa@.discussions.microsoft.com> wrote in message
news:E8CFE7A0-1C04-4324-A258-3EAB1BC2ADD5@.microsoft.com...
> from PC is uninstalled SQLSERVER2000 and related files mdf and log without to
> execute backup database. With a tool of recovery file deleted *.mdf and
> *.log, we have recoverd files. How to do you to recovery the database from
> mdf e log file?

No comments:

Post a Comment