How many mdf files can you use in comprising one database. I know one can
setup primary & secondary but how far down the list can it go? Can you have
30 files (each limited to 50GB)?You are well within the limits of SQL Server. One database can have over 32,
000 files 4 TB each.
You can look-up 'maximum capacity specifications' in BOL.
DeeJay
"kisstene" wrote:
> How many mdf files can you use in comprising one database. I know one can
> setup primary & secondary but how far down the list can it go? Can you ha
ve
> 30 files (each limited to 50GB)?
