SQL Express

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

SQL Express

Post by Pat »

I have Office 2007, and 2010, I have reached the limit of my Access database which bombs out at 2Gb.
Which version of SQL Express should I go for?
What size can the SQL Express database extend to?

User avatar
HansV
Administrator
Posts: 78558
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: SQL Express

Post by HansV »

I'd go for the current version, SQL Server Express 2016. The maximum size of a database is 10 GB. (In the full version of SQL Server, it is virtually unlimited, the maximum size is 1 Exabyte = 1000000000 GB)
There are some other limitations, see SQL Server Express.
Best wishes,
Hans

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: SQL Express

Post by Pat »

Thanks Hans, I was going to add that I had Windows 10.
Doesn't seem to matter.