Since there is no limitation for the Express database transaction log file, you can leave the express database recovery model in either full or bulk logged. You will see that database is 24 GB which is clearly over the 10 GB limitation. This means log files can be in any size.įollowing is the Disk Usage report of the Express database which describes the limitations on the data and log files. However, it is important to note that this limitation is on the data file and the log file is excluded from this limitation. The major limitation in the SQL Express database is that the storage limit which is 10 GB. This edition will provide you with a basic storage option and this article is to examine what maintenance tasks you need to perform to manage SQL Express effectively. If you are not able to spend money on your small databases, SQL Server Express edition is the solution for you.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |