[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 363
  • Last Modified:

MS sql express, 4gb restriction

We are using msql express with current data of 3,68GB. We are planing to upgrade to ms sql 2008 standard but till then i am interested if we will have any problem with 4GB restriction

Database primary data files are using 1,6GB, the other part consist of database transaction log files. Is in the 4GB quota included just primary data files or log files too?

Thank you
0
mertez
Asked:
mertez
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>>  Is in the 4GB quota included just primary data files or log files too?

4 GB limit applies per database with log files excluded and hence its applicable on the data files..
Hence I feel, now you are in the safe stage since you have only around 1.66 GB of data file..
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now