Pembatasan pada MS SQL Express 2008 dan 2008 R2


Beberapa pembatasan pada MS SQL Express 2008 dan 2008 R2 :

  • Ukuran maksimum database : 4 GB untuk versi 2008 dan 10 GB untuk versi 2008 R2
  • Hanya 1 CPU walaupun terdapat lebih dari 1 CPU
  • Hanya dapat utilize RAM maksimal 1 GB saja walaupun terpasang lebih dari 1 GB

 

—-

Great news for SQL Server Express users today! We increased the maximum database size in SQL Server 2008 R2 Express from 4 GB to 10 GB.

You can try it out today – just go to SQL Server 2008 R2 Download Page and select “SQL Server 2008 R2 Express” from the menu on the left side of the page:

http://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx

 

FAQ

Is the database size limit increased in all editions of SQL Server 2008 R2 Express?

Yes, SQL Server 2008 R2 Express with Tools and SQL Server 2008 R2 Express with Advanced Services will allow 10 GB databases as well.

What about CPU and memory limits? Are any other limits changed in SQL Server 2008 R2 Express?

No, the database size limit is the only limit we updated in SQL Server 2008 R2 Express.  SQL Server 2008 R2 Express is still limited to 1 CPU and 1 GB or RAM.

Was the database size limit changed for previous versions of SQL Server Express?

No, the database size limit in previous versions of SQL Server Express (including SQL Server 2005 Express and SQL Server 2008 Express) stays unchanged at 4GB.

 

– Krzysztof Kozielczyk, Program Manager for SQL Server Express

 

sumber : https://blogs.msdn.microsoft.com/sqlexpress/2010/04/21/sql-server-2008-r2-express-database-size-limit-increased-to-10gb/

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

%d blogger menyukai ini: