You are here: MDF / LDF « MsSQL Server « IT news, forums, messages
MDF / LDF

Posted by gurdipv on 09/21/05 13:32

Hello,

I recently deleted the directory
C:\Program Files\Microsoft SQL Server\MSSQL\Data

On my production database server.
I managed using undelete software to get back most of the LDF/MDF files
and reattached them.

But there are a few that simply do not reattach.
Ive tried using

sp_attach_db
sp_attach_single_db

But to no avail.

I realise that the databases were not unattached properly.

Is there a way to get the databases back into Enterprise Manager?
Without starting again or using an expensive product like
officerecovery.com SQL to recover?

I appreciate anybodies help on this.
Gurdip

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация