Request you to give some information and your valuable suggestion in deciding the best procedure to Split Ms SQL 2000 server Database files.
by default SQL was in auto-extandable mode and its growing, now we would like to split them in to few data files and planning to distribute the load across different spindles in RAID arrays to get max I/O.
what will be the idel/best practice to split ? is that by SQL script (Query analyzer) or 3rd party tools to split database files in to multiple files?
how can we confirm the consistency/integrity of DB after splitting?
type of query to run for spliting and mapping DB files after moving to different locations in SAN?
hope that you'll give some valuable information on this,