Re: Log File

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/08/04 

Date: Thu, 8 Jul 2004 05:43:00 +0530

Hi,

Login to SQL server using Query Analyzer:-

sp_detach_db <dbname>

-- this will detach the database from sql server, so move the LDF file to
new location using windows explorer. After this execute

sp_atatch_db <dbname>,'MDF_file_wth_path','LDF_file_with_NEW_path'

Thanks
Hari
MCDBA

"Diane Walker" <ett9300@yahoo.com> wrote in message
news:ea$DRjGZEHA.3664@TK2MSFTNGP12.phx.gbl...
> We are running SQL 2000 Enterprise Edition. How do I setup the log file
to
> go to a different partition? Thanks.
>
>

Relevant Pages

  • Error 1813 or "WHY didnt they call me earlier?"
    ... 3- copy the data file (mdf and ndf's) over the ones from ... 4- start sql server ... >The SQL Server 7.0 database on this server appear after ... >but I get an error telling me that ldf file and mdf file ...
    (microsoft.public.sqlserver.server)
  • Re: Recover SQL Database from suspect status
    ... Stop and start the SQL server and try accessing the webc database ... Suspect database may be due to below reasons. ... MDF or LDF files may be used during the SQL Server service startup ... LDF file might be corrupt or immediate power shutdown caused the LDF to ...
    (microsoft.public.sqlserver.server)
  • Re: Having a problem attaching a database
    ... SQL Server Storage Engine Development ... > having trouble attaching the database to pull the required information. ... Select the database that I want to attach (renamed file in new ... Click OK and a message appears asking if I want to create an ldf file. ...
    (microsoft.public.sqlserver.server)
  • Error 1813 or "WHY didnt they call me earlier?"
    ... I am sitting as second row SQL Server support. ... The SQL Server 7.0 database on this server appear after ... I have create the directory, and put the mdf file ... but I get an error telling me that ldf file and mdf file ...
    (microsoft.public.sqlserver.server)
  • Re: Missing log file...
    ... This will attach the database with MDF file and will create a new LDF file. ... Stop sql server and rename the existing MDF to a new one and copy the ...
    (microsoft.public.sqlserver.server)