SQL Server Express 2008 R2 limitations

Question

When considering to use an Express Edition of SQL Server 2008 for a system that officially is only tested with full editions, what do I need to know about the limitations?

Memory, connections? What about backup and restore features? Can I set up automatic backups of certain databases on the Express edition?

score 3 · Accepted Answer · answered Feb 06 '14 at 12:00

3

Looks like you want this msdn page.

Basically, you're limited to 1 CPU, 1 GB RAM usage, 10 GB database size, no high-availability options, and the bare-bones basics in every other category.

(Regarding the backups, I believe it's doable, but you'll [probably] have to use the SQL Management Studio provided with a proper SQL edition to set those up.)

answered Feb 06 '14 at 12:00

HopelessN00b

53,385
32
133
208

1

And the SQL Agent doesn't start. – MDMarra Feb 06 '14 at 12:02
1

I've gotten around the no SQL Agent for backups thing with scripts that invoke sqlcmd that are kicked off by task scheduler. So it's doable, but it's not built in. – Katherine Villyard Feb 06 '14 at 15:10

SQL Server Express 2008 R2 limitations

1 Answers1