Re: Log File

From: Diane Walker (ett9300_at_yahoo.com)
Date: 07/08/04 

Date: Thu, 8 Jul 2004 06:44:31 -0700

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.
> >
> >
>
>

Relevant Pages

  • Re: [patch] remove MNT_NOEXEC check for PROT_EXEC mmaps
    ... partition, and AT THE SAME TIME want stuff to execute from there (being ... IMHO there should be some policy that can be achieved. ... suggests that there is no strict policy at all any more. ...
    (Linux-Kernel)
  • Re: /lib/ld-2.2.4.so
    ... >I tried this and it seemed to not work on my Linux system. ... >user doesn't have the permission to execute, it is enough to have read ... >bin bzImage bzImage3 bzImage5 dev home lib mnt proc sbin ... >noexec, lets take this partition: ...
    (Vuln-Dev)
  • Re: [patch] remove MNT_NOEXEC check for PROT_EXEC mmaps
    ... partition, and AT THE SAME TIME want stuff to execute from there (being ... libraries or binaries, same thing to me). ... ask the Linux kernel to allow you to execute it, if it lives on a noexec ... Whatever it is, you are executing it, and the goal of noexec ...
    (Linux-Kernel)
  • Re: /tmp on same partition as /
    ... > that its a major security risk. ... very easily to *accidentally* fill your root partition, ... to execute it without moving it to another file system, ...
    (freebsd-questions)
  • Re: help with pagefile
    ... Enquire, plan and execute ... I would not partition the rest of the ... please review these screen shots and tell me what the settings should ...
    (microsoft.public.windowsxp.basics)