26

Change the recovery mode of the database named "model". From this MSDN doc: A new database inherits its recovery model from the model database. The default recovery model of the model database depends on the edition of SQL Server. But this can be changed by anyone that has ALTER permission on the database.


18

Before adding a User you must first create a global Login, under Security -> Logins. Once the login exists you can add them as a User under a particular database.


15

There a few topics on it, but someone posted a good workaround here NET START MSSQL$SQLEXPRESS /f /T3608 SQLCMD -S .\SQLEXPRESS 1>SELECT name, physical_name, state_desc FROM sys.master_files ORDER BY database_id; Now notice those wrong file names; and run following commands ... Note: you need to change the file name location .. 1>ALTER DATABASE ...


14

Sorry to necro here, but just in case someone else hits this page with a similar question, and since there's so little documentation about this... Short: The regular "Enterprise" (non-"core") edition caps the cores at 20, period. The "core" edition has no such cap. This is not a guess, it's a provable certainty. I ran into the specific question "when do I ...


11

Now that it's been in release mode, there's more information available on SQL Server 2012 Express. It looks like you're limited to: 1 physical cpu (up to 4 cores) 1GB of memory use up to 10GB per database.


11

No. According to the well hidden and difficult to follow documentation on MSDN (here) it requires Windows 2008 / Windows Vista or later.


8

As far as I am aware there has been no official announcement of the capabilities of SQL Express 2012, although I have heard rumours that it will be the same as 2008 R2 (1 CPU and 10Gb database limit). Microsoft have released specifications for the standard and enterprise editions.


7

Turned out it was caused by the SQL Server setup. After the "prepare" stage, a shortcut to the "complete" stage will be added to the Start Menu. However, for some reason the shortcut links to the SQL Server Enterprise setup. To complete a SQL Server Express prepared instance, the setup must be launched from the SQL Server Express install media, using the ...


7

Microsoft SQL Server does not support a 'real' load balancing scheme out of the box. AFAIK, this is still true with SQL Server 2012. (Someone will enlighten me if I'm wrong.) It doesn't matter if we are talking about database mirroring or AlwaysOn or clusters. (In order to hammer that point home, MS seems to call SQL Server clusters "SQL Server failover ...


7

I am a SPLA provider, and when I look at the core editions, it states that it is for licensing two cores, as opposed to one processor. The core download and the full download are both the EXACT same size. That tells me that the core edition has NOTHING to do with the core version of windows, it has to do with licensing.


7

I was confused by this too... From my research it seems that Enterprise Core is in fact just the per-core licensing version of Enterprise. (Contrary to your own answer). As a Microsoft Partner, the "Enterprise Core" version was all that was available to me in our Partner Download Portal. I thought it strange that I would be restricted to installing SQL to ...


7

Change the recovery model of the model system database.


7

Back the whole system and the databases up and follow the upgrade instructions and you'll be fine.


7

I got the same error because I had left out the '/' in front of the ConfigurationFile argument. The correct syntax is something like this: F:\setup.exe /ConfigurationFile=C:\setup\ConfigurationFile.ini


7

This TechNet article outlines the requirements and procedure for installing Microsoft SQL Server 2012 on Windows Server core. As you'll see, 2008 is not listed as a supported operating system for this. This is because the .NET Frameworks required for this to run are only supported on core editions of 2008 R2 and later.


6

Express version database size limit is 10GB. source


6

I suspect that this article will help you out: Understanding SSL Support The protocol still uses TCP port 1433, by default, irrespective of SSL being used. The client can request SSL and, if the server has a certificate installed, the server and client will negotiate SSL. The server can be configured to force SSL, which will cause clients that do not ...


5

The shared features directory is set by the first install of SQL and cannot be changed afterwards without uninstalling everything from that SQL version in add/remove programs and then re-installing with the correct directory. Expanding on my comment, the approximate synx and config file for a command line install. rem setup call setup.exe /...


5

If you are in an AD environment, I would recommend using AD accounts for SQL Services. When you do things like backup, if you are running under builtin accounts permissions can become a pain (same with things like log shipping). In other words, I have made the mistake of using the built-in accounts, and learned my lesson :-)


5

Not only do they NOT tell you the difference between Enterprise and Enterprise Core. They have continued this practice of misnaming the downloads into SQL Server 2014. It is very easy to make a mistake and download the wrong version and wind up with a server with only 1/2 of it's cores working... Microsoft should make the following changes: They should name ...


5

I've tried the same on my 2012 Developer instance and had no problems. Ensure that the instance you're connected to is indeed Enterprise or Developer edition by running SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')


5

This sounds like a problem with your SQL Server topology. It sounds like maybe you have Database Engine, Analysis services and client tools all on the SQL Server, but none of those features on the TFS server? If that's true, then you need to run the SQL Server setup on the TFS server (DEVSERVER) and install SQL Client tools on the TFS application tier, as ...


5

Have a look at this post which tells of a similar situation. The author used the SQL Native Client .msi from the \x64\Setup\x64 folder of the SQL 2008 distribution media. Maybe that will do it. If not, you should be ok to uninstall the SQL Native Client 11, install v10 and then reinstall 11.


5

Auto shrink is evil. You shouldn't be manually truncating the log files - if they're growing constantly then that's an indication that the database is using the FULL recovery model and you're not backing up the logs. Depending on your recovery requirements, either start doing regular transaction log backups to keep the log file size down, or switch to ...


5

SQL Server will hold on to the RAM it allocates, so since it doesn't seem to go above 6-7 GB, I would allocate 8GB for SQL and keep 2-4 GB extra for the OS in this case (SQL always does some tasks outside the memory it allocates for sqlserver.exe. It would be a good idea to put this value (8 GB) in the min memory settings for your sql server instance. This ...


5

SQL Server 2012 does not guarantee the order of rows returned in SQL 2012. Neither did 2000, for that matter. (The citation I found for that is actually 2005, but close enough.) Essentially, the SQL Server Query Optimizer is guaranteeing that the internal operator in the query tree will process its input in a particular order. There is no ...


4

Sysprep is supported for SQL 2012 Express as you can see here: http://technet.microsoft.com/library/cc645993(SQL.110).aspx Please note that: You cannot specify Product IDs for a prepared instance of SQL Server Express editions, you cannot upgrade it to other editions and SQL Server tools are not supported for SQL Server SysPrep installations. http://msdn....


4

In previous versions you would set that on the model database, which is the "model" for new databases. I'm assuming it's the same in SQL Server 2012.


4

The uneven performance was likely a combination of the 20-core limit combined with the way that sql server schedules threads on NUMA machines. Unfortunately, SQL Server 2012 doesn't use any intelligence in deciding which 20 cores to utilize, resulting in an unbalanced number of cores per NUMA node. With 32 cores spread across 2 NUMA Nodes, you'll likely ...


4

While SQL-Server 2012 has been tested and and is fully supported by Microsoft, this is not the case for SQL-Server 2008R2. However is it still possible to install and run this version of SQL-Server on Windows Server Core installations. Here's what to do to install SQL 2008R2 on a Server 2008R2 core edition: install dot.NET Framework 3.51 pkgmgr /iu:NetFx2-...


Only top voted, non community-wiki answers of a minimum length are eligible