You’re offline. This is a read only version of the page.
25
Is there a file size limit on the Microsoft SQL Server 2005 v9.00.2047.00 database? If so, what is the limit?
*This post is locked for comments
Miles,
We are running the express version and your answer is exactly what I was looking for and confirms what I had already suspected - that dB size max is 4GB
Thanks,
David
Davy:
Are you running "full version" SQL Server 2005 or the free Express version?
The full version has a max file size of 16 TB; max database size of 500+ TB.
Express has a max database size of 4 GB; not certain about max file size.
Schedule daily Maintenance Plans to keep your database in shape and running smoothly - and to remove the trash that accumulates.
HTH
Aloha,
Miles
Pacific Computer Systems
Miles Baidack
miles@pacificcomp.biz
Supporting Business Since 1985
Phone: (808)395-8156 or (808)277-8156
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (