database size limitations I am accidental DBA. One of my clients has been trying to upload a data file and he's been encountering  error message about database size limitation. He hasn't sent us the exact error information but has asked if the database is set to autosize. I have heard tables being set to auto resize, database autoshrink feature..but what exactly is database autosize? I checked the database properties and the data file is set an initial size and autogrowth is enabled and is set to unrestricted growth and the transaction log has a restricted growth feature enabled.
Could you help me here?
Database size is limited in the express edition only. In other editions the size is limited only to your storage subsystem restrictions. If it is not express edition, ask your client if it is the full transaction log file issue which he is interpreting as a database size limitation. In that case you either need to back up the log files or increase log file size or truncate the log file with dbcc, depending on your database environment, storage subsystem and recovery model.