Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sql-server-express]

For questions about Microsoft SQL Server Express (except Express LocalDB).

Microsoft SQL Server Express, a freely downloadable and distributable version of Microsoft's SQL Server relational database management system, comprises a database specifically targeted for embedded and smaller-scale applications. It has restrictions that make it unusable for large-scale applications. For more, see http://www.microsoft.com/sqlserver/en/us/editions/express.aspx or http://en.wikipedia.org/wiki/SQL_Server_Express.

196 questions
34
votes
3 answers

Is the SQL Server Express memory and CPU limit per instance?

If I have 8GB of RAM in a server and I run 4 instances of SQL Server Express, will the total memory limit used by SQL Server be 1GB or 4GB? Would it be advisable to run multiple instances like this to enable each database to make better use of…
wizzardmr42
  • 460
  • 1
  • 4
  • 8
24
votes
1 answer

Where is SQLCMD.EXE in SQL Server 2014 Express?

Using "SQLCMD.EXE" to back up my SQL Server Express databases for years I just discovered that after installing the 2014 version, I found no SQLCMD.EXE anymore. In previous versions it was located at C:\Program Files\Microsoft SQL…
Uwe Keim
  • 887
  • 2
  • 13
  • 24
22
votes
1 answer

Why does SQL Server 2012 Express use 9.5GB of RAM on my server?

I am building an application in which I plan to embed SQL Server 2012 Express as the primary datastore. When testing on my development machine (Win7-32 with 3GB RAM), I never observed the sqlservr.exe process to use more than 1GB of RAM as I would…
Dan
  • 545
  • 2
  • 6
  • 14
20
votes
5 answers

Download SQL Server Profiler for SQL Server Management Studio

How can I profile a SQL Server 2008 database to see code that's being executed on a particular database? I remember using the SQL Server profiler, but I don't see it in SQL Server Management Studio after downloading SQL Server 2008 R2 Express. …
JustBeingHelpful
  • 2,116
  • 18
  • 45
  • 61
18
votes
1 answer

Messages about parallel redo

Parallel redo is shutdown for database '' with worker pool size [2]. Parallel redo is started for database '' with worker pool size [2]. Starting up database '' I see this on a client PC a lot in the Windows Event Viewer (Event Id 49930 or…
juFo
  • 309
  • 1
  • 3
  • 8
13
votes
5 answers

SQL Server 2008 Full Text Index Never Seems to Complete

Our website has a SQL Server 2008 R2 Express Edition database with full-text indexing for our website search. Each time a new record is added or updated in one of the indexed tables, the indexing process never seems to complete. I have been…
Jargs
  • 323
  • 3
  • 8
13
votes
1 answer

Move folder of SQL Server LocalDB instances from the default location

I get multiple errors with LocalDB (startup error, can't create DB from SQL Server Management Studio and also multiple issues when trying to restore a backup) and none of the fixes I found are helping anything. It seems to me that all errors have…
Piedone
  • 233
  • 1
  • 2
  • 6
13
votes
2 answers

Do SQL Server Express Editions support CLR procedures?

Do SQL Server Express Editions (2005, and 2008) have support for installing, enabling and running CLR Stored procedures and functions.
adopilot
  • 2,443
  • 8
  • 31
  • 46
10
votes
3 answers

How to check if I am hitting the Express Edition size limit?

I am confused. AFAIK SQL Server 2005 Express has a limit of 4GB database data size. However I have the following results from sp_spaceused: How can I check if my DB is hitting the size limit? Is unallocated space the space left untill I hit the…
g00fy
  • 211
  • 1
  • 2
  • 4
10
votes
2 answers

SQL Server 2016 high idle CPU and queries extremly slow

I have a ~10 day old installation of WinServer2012R2 and SQL Server Express 2016 for testing. I am the only user on this machine. A database with a .bak from SQL Server 2005 of ~250MB is restored without any issues. After a reboot of the machine the…
AndreasS
  • 229
  • 2
  • 3
  • 7
9
votes
1 answer

Why the instance name of SQL Server Express is changing?

I'm workig on a web app which is using SQL Server Express (Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64) Oct 28 2016 18:17:30 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 6.3 (Build…
maniacz
  • 93
  • 3
9
votes
2 answers

Differences between the different installers of SQL Server 2014 Express

I'm trying to understand the differences between the different installers of SQL Server 2014 Express. If you are able to tell me whatever you can or find documentation on them, I'd appreciate…
JustBeingHelpful
  • 2,116
  • 18
  • 45
  • 61
8
votes
4 answers

Restore backup fails - not enough disk space

I have a backup that's about 6Gb. It's a "light" backup of the original (with the log tables purged), which is about 14Gb. I try to restore the backup on my SQL Express local server. It fails with a message like : System.Data.SqlClient.Error:…
thomasb
  • 193
  • 1
  • 1
  • 9
8
votes
1 answer

Why are duplicate permissions appearing on the securables GUI in SSMS?

Why are duplicate permissions appearing on the Securables GUI?
Shawn H
  • 223
  • 2
  • 7
8
votes
2 answers

Can I have full backups on multiple disks?

Currently, I've only got one backup file, IMTDB.bak, and it's on the same HDD as the Database itself. I want to increase the redundancy of this DB backup by essentially "copying" it to another disk, but I get an error "Backup failed for Server, The…
ijustlovemath
  • 363
  • 3
  • 14
1
2 3
…
13 14