Re: DB Recovery

From: Jasper Smith (jasper_smith9@hotmail.com)
Date: 02/17/03 

From: "Jasper Smith" <jasper_smith9@hotmail.com>
Date: Mon, 17 Feb 2003 22:28:25 -0000

You can try using sp_attach_single_file_db

Depending on the state of the mdf file this may
attach and recreate an empty logfile for the database.
If that fails there are other more convoluted ways
to do this but they are very much "at your own risk"
and the best course of action may well be to contact PSS 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Gino Reynoso" <greynoso@purebeauty.com> wrote in message
news:01b101c2d6ce$6972bf50$a401280a@phx.gbl...
> is it possible to recover a DB when you only have the MDF
> and no transaction log?
>

Relevant Pages

  • Re: "Hidden" Replication Stored Procedures?
    ... aforementioned MDF file in Notepad and doing a quick search, ... Is there a way to have the Resource Database appear in the list of Databases ... Chris Jones ...
    (microsoft.public.sqlserver.replication)
  • Re: Problem with updating MDF Data file as opposed to updating a running SQL Server DB
    ... In Visual C# Express, I created a windows application, then "Added" a ... Doing this created an MDF file in my project folder, ... database into my database explorer window in the IDE. ... It would seem with this option, then one could use a SQL Server MDF ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: viewing mdf files
    ... data file that together with a .ldf are the basis for a SQL Server database. ... you should not generate a .mdf file in the first place. ... > So to write the SQL to do the report is doable. ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: how to transform an MDF file o a permanent database?
    ... What i want is to make that .mdf file permanent in the central database, ... SQL Server Documentation Team ...
    (microsoft.public.sqlserver.setup)
  • Using multible computers with Access
    ... Database Splitter) you can have one central back-end (the ... One is to have students log into the ... >would be used for the proctors. ... >mdf file, or would it better to have one mdf and have ...
    (microsoft.public.access.tablesdbdesign)