Isabelle2378 (4/30/2013)
Hi,I have a filegroup with one large datafile that is 300GB and I want to create 10- 30GB files and spread the data across them for better performance.
Create a new filegroup with the new files and move the objects to the new filegroup. Just out of interest, why 10 files?
Unless you have the underlying disk structures to support this it's going to provide no benefit having multiple files. In fact the file switching and management overhead of the round robin striping could even affect performance.
Once you run dbcc shrinkfile with the emptyfile parameter against a database file sql server no longer writes to the file, it assumes you're going to remove it. You should remove the file and add a new one if you need to, since you have 10 already do you really need to??
Isabelle2378 (4/30/2013)
3) stop/restart SQL Services so that I was able to shrink down original 300GB datafile
Explain please??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉