?
Solved

SQL Express for Win8

Posted on 2013-06-01
5
Medium Priority
?
513 Views
Last Modified: 2013-06-03
Hello Experts,

Is there a SQL EXpress version for Win8?

I use SQL EXpress R2 2008 on Win7 with SQL Management Studio to serve a small office, but when I tried to run the 2008 installer it gave me compatability warning, which I did not want to risk.

I also tried SQL 2012, but there are so many versions available and did not know which to choose.

As well, if 2012 is it, does it have the same restrictions like 2 GB DB? Any other restrictions like number of simultaneous connections, etc?

Thank you,
0
Comment
Question by:APD Toronto
  • 4
5 Comments
 
LVL 22

Expert Comment

by:Haresh Nikumbh
ID: 39213156
Download from below location which has given Path for download and description of each component

http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx
0
 
LVL 22

Expert Comment

by:Haresh Nikumbh
ID: 39213160
database size limit is 10 gb

reset limitation you can check it out below

http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx
0
 

Author Comment

by:APD Toronto
ID: 39213172
any other limits, rather than 10GB.?

By the way, how do i check how big is my db towards thid 10gb?
0
 
LVL 22

Expert Comment

by:Haresh Nikumbh
ID: 39213177
http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx

if you look at this link which has given all comparison betn express and full edition
0
 
LVL 22

Accepted Solution

by:
Haresh Nikumbh earned 2000 total points
ID: 39213181
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

594 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question