Log File

We are running SQL 2000 Enterprise Edition. How do I setup the log file to
go to a different partition? Thanks.Take a look at sp_attach_db and sp_detach_db in BooksOnLine.
--
Andrew J. Kelly SQL MVP
"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.
>|||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.
>|||Thank you. I'll give it a try.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23C0$0vIZEHA.2408@.tk2msftngp13.phx.gbl...
> 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.
> >
> >
>|||Thank you. I'll give it a try.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OGWEeCIZEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Take a look at sp_attach_db and sp_detach_db in BooksOnLine.
> --
> Andrew J. Kelly SQL MVP
>
> "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.
> >
> >
>