Solved

moving system database log  files

Posted on 2012-04-02
1
358 Views
Last Modified: 2012-04-03
Hi,

When i install sql server it always installs the log and data files of all the system databases into the same directory - how can i split these out - so i can put the system datafiles and logs into different directories

thanks
H
0
Comment
Question by:hraja77
1 Comment
 
LVL 19

Accepted Solution

by:
Rimvis earned 500 total points
ID: 37799619
Hi, hraja77

Check this:
http://msdn.microsoft.com/en-us/library/ms345408%28v=sql.105%29.aspx

But really there is no benefit of moving master or msdb log files to separate disk. These databases do not change often, so you will not improve performance. On the other hand, moving tempdb to separate drive CAN help.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
query execution hang 5 31
SQL SELECT query help 7 41
Whats wrong in this query - Select * from tableA,tableA 11 31
sql how to count case when 4 16
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question