Is the max limit of 4 GB on sql server 2005 express .mdf + .ldf or for .mdf only ? Kindly clarify. Thanks.
views:
71answers:
1
+3
A:
MDF + NDF's - basically the data files.
Logs dont count.
On 2008, File system store also does not count.
TomTom
2010-03-15 09:58:03
can you elaborate FILE SYSTEM SORE ?
HotTester
2010-03-15 10:12:51
@TomTom: I'm sure you meant **FILESTREAM** storage - storing large files in the SQL Server filesystem under transactional control
marc_s
2010-03-15 10:15:47
Yeah, sorry ;) FILESTREAM.
TomTom
2010-03-15 10:19:36
so does FILESTREAM in sql server 2005 express count in the 4GB limit ?
HotTester
2010-03-15 11:10:18
FILESTREAM does not exist in server 2005, it was a new feature for 2008
Kevin Ross
2010-03-15 14:50:23
Which is pretty exactly why I said "on 2008" ;)
TomTom
2010-03-15 14:58:41