Wednesday, March 7, 2012

How is the 4 GB limit of SQL server express calculated

Hi
I wonder how the 4 GB limit is found.
Is it the size of the datafile only, or does the size also inlcude the
transaction log?
Regards
Kjell Arne Johansen
Kongsberg Maritime as
Hello,
The 4 GB database size limit applies only to data files and not to log (LDF)
files. However, there are no limits to the number of databases
that can be loaded/created to the SQL server instance.
Thanks
Hari
"Kjell Arne Johansen" <KjellArneJohansen@.discussions.microsoft.com> wrote in
message news:620B8D2E-5810-4C05-B168-595EAC94D712@.microsoft.com...
> Hi
> I wonder how the 4 GB limit is found.
> Is it the size of the datafile only, or does the size also inlcude the
> transaction log?
> Regards
> Kjell Arne Johansen
> Kongsberg Maritime as
|||Thank you for your answer.
"Hari Prasad" wrote:

> Hello,
> The 4 GB database size limit applies only to data files and not to log (LDF)
> files. However, there are no limits to the number of databases
> that can be loaded/created to the SQL server instance.
> Thanks
> Hari
> "Kjell Arne Johansen" <KjellArneJohansen@.discussions.microsoft.com> wrote in
> message news:620B8D2E-5810-4C05-B168-595EAC94D712@.microsoft.com...
>
>

No comments:

Post a Comment