Friday, March 30, 2012

max no of datafiles

whats the maximum no of datafiles & logfiles sqlserver
supports.
thanksFrom BOL
32,767 files per database
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"kumar" <sqldba2004@.yahoo.com> wrote in message
news:149c401c414cd$7f963c60$a301280a@.phx
.gbl...
> whats the maximum no of datafiles & logfiles sqlserver
> supports.
> thanks

No comments:

Post a Comment