Re: Attaching a Database

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/01/05 

Date: Sat, 1 Jan 2005 09:35:29 -0500

Try Tom's suggestion first but if that doesn't work you can have a look
here:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599 

-- 
Andrew J. Kelly  SQL MVP
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message 
news:%23%23J1x%23$7EHA.3708@TK2MSFTNGP14.phx.gbl...
> Check out sp_attach_single_file_db in the BOL.
>
> -- 
>   Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON   Canada
> www.pinnaclepublishing.com
> .
> "Amit-SQL-DBA" <AmitSQLDBA@discussions.microsoft.com> wrote in message
> news:4281944D-1714-4A69-8664-BFFACEC4649B@microsoft.com...
> Hi Friends
>
> Can i attach a database without having its LOG file. Unfortunately all LOG
> backups and original log files are deleted from the server. I've the MDF
> file
> only.
>
> Kindly guide me.
>
> Amit
>

Relevant Pages

  • Re: **to trace what has happened**
    ... Andrew J. Kelly SQL MVP ... time should I save the changes as a log file, or is there any place to ... SQL Server will not log the events by default. ... I don't want to monitor the changes simentanously, I want to refer to ...
    (microsoft.public.sqlserver.security)
  • Re: PerfMon recording to SQL 2005
    ... I've been out of the SQL world for a couple years so dusting ... A System DSN, specifying windows authentication, and change to an ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Re: PerfMon recording to SQL 2005
    ... I've been out of the SQL world for a couple years so dusting off ... A System DSN, specifying windows authentication, and change to an existing ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
    (microsoft.public.sqlserver.server)
  • Re: Poor performance after upgrading to sql server 2005
    ... Andrew J. Kelly SQL MVP ... problem if the optimizer could not handle subqueries but I know for a ...
    (microsoft.public.sqlserver.setup)
  • Re: recover mode and the transaction log file question
    ... Andrew J. Kelly SQL MVP ... "Dan Guzman" wrote in message ... > changing the recovery model to FULL. ... >> I have setup the log file to not grow at all. ...
    (microsoft.public.sqlserver.programming)