Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to split MDF and LDF files?

Author  Topic 

oxegg
Starting Member

6 Posts

Posted - 2010-05-27 : 02:28:51
I want to advance SQL Server performance.
So I want to consult how to split MDF and LDF files?
Thanks!

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-05-27 : 04:11:54
You can add additional data files, typically they get the .ndf extension. Look up ALTER DATABASE in Books Online.

There's no point in splitting a log file for performance. SQL uses them sequentially, not in parallel.
Adding additional data data files will only help performance if they are on different physical drives and if your bottleneck was IO-related.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -