Placing Log on another drive

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jack A (anonymous_at_discussions.microsoft.com)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 09:12:39 -0700

We have a database that uses the same drive for logs and
data. After a new disk has been installed what is the
easiest way (and reliable) way to move the logs to the new
disk.

I'm thinking of dumping and restoring the database using
the log on clause of restore. Any other ideas ?

TIA,
Jack

Relevant Pages

  • Re: High Avg. Disk Queue Length When Opening Shared Calendars
    ... Let's assume 10K spindles, a 3:1 read/write ratio, and IOPS/user of 1. ... Now let's look at the logs. ... the database LUN would become a bottleneck prior to the log LUN. ... A disk bottleneck on the database LUN. ...
    (microsoft.public.exchange.admin)
  • Re: Basic query tracing and profiling question...
    ... L: Oracle Logs 387GB ... # been enabled using ALTER DATABASE ARCHIVELOG. ... tablespace all on ONE disk is a recipe for disaster. ...
    (comp.databases.oracle.server)
  • Re: Disk Configuration for AD domain controllers
    ... need guidance for configuring the disk drives. ... I read that it is recommended to store the AD database and logs on a ... AD is not such a large database as Exchange for example. ... If your RAID controller has a battery backup, it is usually safe to leave write cache enabled on the disk. ...
    (microsoft.public.windows.server.general)
  • Re: High Avg. Disk Queue Length When Opening Shared Calendars
    ... Now let's look at the logs. ... the database LUN would become a bottleneck prior to the log LUN. ... You didn't name the location of the SMTP directories (we'll assume the boot ... A disk bottleneck on the database LUN. ...
    (microsoft.public.exchange.admin)
  • Re: Exchange performance
    ... Having transaction logs on the same physical volume will not allow you to ... that is why I have both database files and log files on same logical drive ... BTW - just so you understand, Full Text indexing does increase the load ... Disk que lenght indicator bar at the top constantly and shows avg. ...
    (microsoft.public.exchange.admin)