on 06-04-2008 11:27 PM
Hi,
on MSSQL we have 3 data files and 1 trans log file.
Becouse of 2quad core procesors on DB host we want to have 8 data files equally occupied.
Any idea how to do that on MSSQL level?
Urban
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Because of 2quad core procesors on DB host we want to have 8 data files equally occupied.
it is not necessary.
check Note 363018 - File management for SQL Server
regards,
kaushal
Not sure if there is a simpler solution to it, but I would think about exporting the database to a dump file, then dropping database, recreate database with 8 files and later reimporting the database dump.
Fahad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.