Proper way to move Log files to another drive

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bill Bradley (wdbradley3_at_comcast.net)
Date: 04/19/04 

Date: Sun, 18 Apr 2004 23:09:04 -0600

I'm running a program that creates a database in the default instance of
SQL2K. For speed, I have separate drives for OS, SWAP, APPS, SQL, and LOGS.
I installed the SQL program to the APPS drive, with the databases being
installed on the SQL drive. When I installed my program, I installed it to
the APPS drive, and it created its database, and log file, in the default
instance's database folder on the SQL drive.

I ran the program once, to get things setup, then, used SQL Enterprise
Manager to detach the database, and I copied the log over to the LOGS drive,
then reattached the database, and, repointed the database to its log's new
location.

Everything seems to work right, so, I assume I did that OK.

My question is on all the other log files for the default databases--should
I do the same procedure to all of them, and move ALL log files to the
separate drive?

NOT a SQL expert, and, not really sure what all the other databases are used
for...

Thanks!

Relevant Pages

  • Re: Advice Requested : Disaster Recovery with 2 Drives (No Raid) with SQL Server 2008
    ... so we need frequent copies of the database for testing, ... Andrew J. Kelly SQL MVP ... But by placing the backups on the same drive as the data or logs you risk loosing data if one of the drives crashes since you will loose backups and either the log or data files. ...
    (microsoft.public.sqlserver.programming)
  • Re: New install of SBS and where to put SQL and exchange
    ... One thing to add about partitions though - shadow copy also has a bearing on ... database drives so those should be separate from user data which you do want ... SBS is one busy machine, exchange and sql, are ... drives with a multi-channel RAID controller? ...
    (microsoft.public.windows.server.sbs)
  • Re: Mapped Drive
    ... SQL does not support mapped drives for database or transaction log ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: IIS/SQL Server Hardware Recommendations?
    ... > settings for SQL 2000. ... All drives RAID via controller card, ... Set the database sizes bigger than you need, ...
    (microsoft.public.inetserver.iis)
  • RDO cant create object - error 429
    ... I have an old set of VB6 apps that use RDO to connect to SQL 2K (been ... connecting to the same database on 3 different servers, ...
    (microsoft.public.sqlserver.programming)