Skip to main content

Questions tagged [sql-server-express]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
50 views

SQL Server Express mdf file is 50+gb

Good day, I have a SQL Server Express database running on a POS register where the mdf file is 50+gb. When I run the select @@version I get the following: Microsoft SQL Server 2017 (RTM) - 14.0.1000....
Sean Harricharan's user avatar
0 votes
2 answers
50 views

Yet another Replicated transactions are waiting for next Log backup or for mirroring partner to catch up

We have a partial transactional replication setup in our environment to make a data subset available to another application. Application Server 1 -> Tables1.row1/row2/row3 -> Application Server ...
Rob Howe's user avatar
2 votes
1 answer
86 views

SQL Express CPU limitation ignored

I have a SQL Express 2014 running on a VM with 12 cores SQL Express limitations state that it should be limited to either 4 cores or 1 socket, but when I run this query: select count(1) "Nb ...
Dominique Boucher's user avatar
0 votes
0 answers
50 views

OPENROWSET in Linux container as AD account

We are building a pseudonymization solution as sort of a proxy between on-prem SQL Server and Azure Data Factory to pull things to the cloud. The pseudonymization parts of it are already on their way ...
esrange's user avatar
0 votes
1 answer
40 views

Upgrade SQL Server Server Express to Licensed Enterpise edition?

we have sql server express edition 2017 with default instanc ,now we want to upgrade it to Enterprise Licensed Edition 2017 with default instance in the same server At first I thought I had to ...
yamihero777's user avatar
0 votes
0 answers
23 views

I need to create a SQL Server 2019 Express database from a SQL Server 2022 database [duplicate]

I have developed a database in SQL Server 2022 (and have SSMS), I need to recreate and include all data from that database on a different server which contains SQL Server 2019 Express. When in SSMS, I ...
mchapman13's user avatar
0 votes
1 answer
160 views

SQL Server Replication Licensing

Production database is hosted on a SQL Server Standard instance and is replicated using merge replication with web synchronization to 10 subscriber databases hosted on 10 separate SQL Express server ...
db-hopper's user avatar
0 votes
1 answer
54 views

Is there a way to automate back-up on SQL Express LocalDB?

I am new to the gis world, and my boss wants me to find a way to automate the process to create back-ups on a local SQL Express DB. I know that I can create one for nonlocal DBs, however, I was ...
user avatar
0 votes
1 answer
516 views

SQL Server 2019 Express limited to 1 socket/4 cores per instance. Can different instances then use different sockets?

We have a SQL Express 2019 server with 3 instances. The VM has 2 sockets each with 2 cores. The SQL Express licensing specifies that a SQL Express instance can use the lessor of 1 socket or 4 cores. ...
cbedwards's user avatar
0 votes
0 answers
138 views

How to copy a database to another server with only some of the rows

Trying to copy a database from a hosted server to a local server for testing purposes and am trying to avoid exporting the whole database as a .bacpac file as there are some tables with tens, maybe ...
user avatar
0 votes
0 answers
122 views

install database backup from SQL Server 2017 to local PC with SQL Express 2022

I am assisting a client who has recently retired from his original business and is setting up a smaller professional property management partnership. He has been instrumental in setting up a tailored ...
Frank Kay's user avatar
2 votes
1 answer
382 views

Stored procedure times out despite very low cpu_time and logical reads/writes

I'm developing a service locally that uses SQL Server Express as a database. I'm seeing strange behavior where a stored procedure is executing several times in a row (with different parameters), and ...
Bob Meyers's user avatar
0 votes
1 answer
329 views

Move SQL Express 2014 database to existing SQL Server 2019 Standard Instance

I have a SQL Express 2014 instance on a server with 1 database that has 1 table. I would like to move that database to an existing SQL Server 2019 Standard instance that is on a different server. The ...
Mary Martin's user avatar
0 votes
2 answers
352 views

Database not shrinking and cant insert data even thought file has free space

I have SQL Server Express 2019 on my local system on a large SSD with >50Gb free disk space. I had a 14Gb database on production, which I copied, deleted a bunch of old data, and reduced the size ...
Vaibhav Garg's user avatar
0 votes
1 answer
544 views

Can not enable lock page in memory in SQL Server Express edition

For enabling Lock Page In Memory, I tried to do this: first of all I find my SQL Server account name with this code: SELECT service_account FROM sys.dm_server_services This code returns: NT Service\...
alirezasejdei's user avatar
0 votes
0 answers
969 views

SQL Error: Could not find stored procedure 'sp_cleanup_history_table'

Seeing errors in the SQL error log hourly on a recently patched SQL Express 2017 CU26 instance. Errors are below. Feels like something system generated from the stored procedure name but very little ...
Stockburn's user avatar
  • 431
0 votes
2 answers
9k views

How to increase database size in Microsoft SQL Server Express?

I have downloaded Microsoft SQL Server Express version. I have created a database name ArcGIS. By default, it has provided me space of 16 MB, see pic. I would like to increase the size of this ...
Riz's user avatar
  • 13
1 vote
1 answer
593 views

Does SQL Server 2019 automatically un-compress data when it is queried by an application? [duplicate]

We are using SQL Server Express 2019 and have inevitably ran into the 15GB cap. I now have to figure out a way to quickly compress data since we cannot buy a license at the moment. At the moment it is ...
Ivan Snyman's user avatar
-1 votes
1 answer
805 views

Recovering SQL database when OS crashed

I was working on a DB design its almost finished. But missed to take a backup. While working due to some reason my OS got crashed (Win 10) and nothing helped to recover it. But I am able to access the ...
sanforall's user avatar
1 vote
0 answers
30 views

Last year's totals won't group by hour

I have a PowerShell script with a query to display yesterday's totals, as well as last year's same day totals, by hour for comparison. Yesterday's totals display by hour fine, but last year's list the ...
Jared Severson's user avatar
4 votes
1 answer
825 views

No parallelism in Express Edition of SQL Server

I have SQL Server 2019 Express Edition (CU8) on Windows Server 2019 (1809 version) and all of my queries go serial with NoParallelPlansInDesktopOrExpressEdition in NoparallelPlanReason property. Is it ...
jericzech's user avatar
  • 945
0 votes
4 answers
101 views

MS SQL Express - Find when a Query was run

I have an ecommerce website in .NET and using MS SQL Server Express, Version info: Microsoft SQL Server 2014 - 12.0.4100.1 (X64) Apr 20 2015 17:29:27 Copyright (c) Microsoft Corporation Express ...
Yoni's user avatar
  • 109
2 votes
2 answers
731 views

How to allow a certain domain user to create databases on a remote SQL instance?

I want to allow for a certain domain user to be able to create databases on a remote SQL instance. What steps are necessary and is it possible to perform those steps programmatically in a C# ...
Elena2020's user avatar
-1 votes
1 answer
519 views

Is there any possibility to use SMO objects to copy a database from MS SQL Server 2014 Express (server address) to localhost?

I need to implement in c# a functionality for copying a certain database from server address to localhost (I'm aware of the backup/restore option - I have this implemented when I want to export and ...
Elena2020's user avatar
0 votes
1 answer
2k views

What is the available SQL Server Express database size? [duplicate]

SQL Server Express allows the maximum of 10GB/10240MB for a database size. I have a database which currently is ~8000 MB in size. The unallocated space is ~7000 MB. The question is: how many megabytes ...
user avatar
0 votes
1 answer
873 views

Creating Linked Server Object to same instance

I'm trying to create a Linked Server Object back to the same SQL Express 2014 server instance (see below for the context), but I'm hitting the following error... Cannot initialize the data source ...
freefaller's user avatar
2 votes
0 answers
669 views

Sql Server Express edition - Could not allocate space for object [Table] in database [DB] because the 'PRIMARY' filegroup is full

I have reached the Sql Server Express edition limit of 10 Go of space per database and for every new INSERT I have this error : 2020-08-10 14:21:58.75 spid67 Could not allocate space for object [Table]...
tomahim's user avatar
  • 121
1 vote
2 answers
48 views

SQL Server Express Edition feature and upgrade concerns

I want to install and learn T-SQL with SQL Server. The lightest edition that I can find is the Express Edition 2017. Will the express edition support procedures, triggers, dynamic sql, PIVOT, ...
halfwind22's user avatar
9 votes
1 answer
873 views

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 ...
maniacz's user avatar
  • 93
0 votes
0 answers
861 views

MSSQL Express: linked server from Access database on network path

I run Microsoft SQL Server Express 64-bit version 14.0.2027.2 (X64) on Windows 10 Pro 10. I have trouble to set the appropriate network UNC path and other settings for the linked server. My ...
radimmachu's user avatar
0 votes
1 answer
325 views

SQL Server Express 2008R2 - restore db failing due to size limit, but file is under 10GB

I'm trying to restore a live db to a test db, but I keep getting a '..failed because the resulting cumulative db size would exceed...limit of 10240' error, yet my database is under 10GB, I feel like ...
hap76's user avatar
  • 15
2 votes
2 answers
2k views

How to install SQL Server 2017 Express in "Quiet Simple" mode without an extraction folder?

I need to install SQL Server 2017 Express with as little user interaction as possible. I am using the SQLEXPR_x64_ENU.exe setup file that I found a Microsoft download for. The installer I am currently ...
musefan's user avatar
  • 252
3 votes
2 answers
217 views

Regarding Sql server 2014 express edition

I need to know if adding another data file in a database (let say MYDB) in express edition will have another 10 GB size or 10 GB will be the total size of all the data files we add in a database. ...
Chandan's user avatar
  • 31
0 votes
3 answers
664 views

Does SQL Server 2017 Express install on Dual CPU server?

A customer wants to rent a dedicated Server for their site. They do not need more than SQL Express 2017, for the time being, but they have been offered a dual Xeon system. Does SQL Express install ...
gthalassinos's user avatar
1 vote
2 answers
81 views

Backing up SQL Server Express Edition on a VPS

I'm considering installing SQL Server Express Edition on a VPS. My understanding is that, among the limitations of Express Edition, some of them involve features that facilitate backups. Can someone ...
Jonathan Wood's user avatar
1 vote
1 answer
23 views

In place upgrade from Express 2005 SP 4 to Express 2014, does database size limitation follow?

We are currently attempting get around a file size limitation issue with our database. The database file size hovers around the 4GB mark (the database size limit is 4GB in SQL Express 2005). We always ...
magneticprawn's user avatar
0 votes
1 answer
1k views

Sql Server - Multiple errors regarding to memory in error log

MSSQL-Server 2017 Express Edition runs on my Linux server. The server has 4GB RAM. The total size of DB is 300MB. My website and the sqlserver are on the same server, it's a small website with max of ...
Offir's user avatar
  • 127
0 votes
1 answer
161 views

Database Consistency History fails in SQL Server 2017 Express

When I run the Database Consistency History report using MSSM I get an error message: unable to retrieve data for this section of the report. Following error occured Msg 19050, Level 16, State 5 ...
Kirsten's user avatar
  • 185
2 votes
2 answers
15k views

‘PRIMARY’ filegroup is full. How do I increase temdb size in SQL Server Express 2017?

When I reindex a particular table DBCC DBREINDEX(@TableName, '',90) I get an error Level 17, State 2, Procedure aareindex, Line 21 [Batch Start Line 0] Could not allocate space for object ‘...
Kirsten's user avatar
  • 185
0 votes
1 answer
72 views

After new row INSERT statement, use newly created PK as FK in a second INSERT statement within the same Stored Procedure

Using SQLExpress -- I have a table Orders that contains a PK of order_id. I have a second table Items that contains model and quantity along with a FK of order_id. I am using a gridview to collect ...
Kalen Kaczor's user avatar
2 votes
2 answers
2k views

Cannot find Database Mail feature in SQL Server Express 2012 SP1

I need to use SQL Server Database Mail feature in my project. However Database Mail seems not available on my development instance. There should be a 'Database Mail' node in the Object Explorer. In ...
bluearth's user avatar
  • 131
4 votes
1 answer
3k views

Scripting a Maintenance Plan in SQL Server Express

How would I run each aspect of Ola Halengren's sql maintenance plan on SQL Express? It's my understanding that each job should be run in a specific order. I'm sure that a .bat or cmd file can do ...
Dave Morse's user avatar
0 votes
0 answers
76 views

Migrating SQL Server 2012 Web Edition to Azure

I am trying to migrate to Azure I have gone through this article Migrate SQL Server to a single database or pooled database in Azure SQL Database online using DMS, However since I am having SQL Server ...
Ibrahim Magdy's user avatar
1 vote
1 answer
232 views

What is using all my space?

I'm using SQL Server Express 2008 R2 and a third part application has its database on this database server. The database seems way bigger than I would expect considering what it is actually doing. ...
David P's user avatar
  • 111
2 votes
1 answer
698 views

Reviewing the design of a database about animals of two distinct species

I am creating a small database using SQL Server Express 2017. There are two animals (Foxes and Elephants). The Foxes table will have the columns: Identifier, Species, BodyLength, and FurColour. The ...
user avatar
17 votes
1 answer
69k views

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 ...
juFo's user avatar
  • 299
1 vote
0 answers
866 views

SQL Server Express 2017 database size limitation

I have a database hosted on SQL Server Express 2017. The size was small like 200MB. Today I have copied 24GB tables to the same database from external database hosted on different server. The ...
Nano's user avatar
  • 139
3 votes
1 answer
4k views

Is there an Express version of Azure SQL DB?

With on-premise SQL Server, there are editions such as Express, Web, Standard, and Enterprise. Do those editions (or an analog) exist in Azure SQL DB, especially Express? My Google-Fu is failing ...
SQLDoug's user avatar
  • 237
2 votes
1 answer
941 views

Connecting to SQL Express Server 2017 with SQL Server Authentication Remotely

I have two systems that are on the same network. I am able to ping back and forth between these systems with their IP address and with their system names. I have enabled the TCP port 1433 inbound and ...
Jack's user avatar
  • 21
0 votes
1 answer
2k views

How to trace security_error_ring_buffer_recorded errors in SQL Server 2014 Express

Just so everyone doesn't have a high expectation of my level of knowledge on this topic, I'm not a DBA; I'm a .NET developer who has to try and figure this out by virtue of being "the one most likely ...
SEFL's user avatar
  • 1