|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
![]() |
|
|
LinkBack | Outils de la discussion |
|
|
#1 |
|
Messages: n/a
Hébergeur: |
I lost the log file but I have a MDF file in sql 2005, the log file backup
is bad too so how to recoiver the data for a DMF only ? |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
You might look up sp_attach_single_file_db in Books on Line
http://msdn.microsoft.com/library/de...ae-az_4wrm.asp Depending on what the state of the database and log was when you lost the log, this may or may not work. -- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm "Carlos" <palcar@gmail.com> wrote in message news:OqhDJCE$GHA.4300@TK2MSFTNGP03.phx.gbl... >I lost the log file but I have a MDF file in sql 2005, the log file backup >is bad too so how to recoiver the data for a DMF only ? > |
|
![]() |
| Outils de la discussion | |
|
|