Questions tagged [sql-server-express]
For questions about Microsoft SQL Server Express (except Express LocalDB).
195 questions
1
vote
1
answer
101
views
SQL Server Express mdf file is 50+gb
I have a SQL Server Express database running on a POS register where the mdf file is 50+gb. When I run select @@version I get:
Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:...
0
votes
2
answers
264
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 ...
- 1
2
votes
1
answer
104
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 ...
- 3,257
0
votes
0
answers
59
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 ...
- 1
0
votes
1
answer
52
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 ...
- 19
0
votes
0
answers
24
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 ...
0
votes
1
answer
264
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 ...
- 13
0
votes
1
answer
65
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 ...
ANON
1
vote
1
answer
639
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. ...
- 13
0
votes
0
answers
190
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 ...
Maen Enma
0
votes
0
answers
130
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 ...
2
votes
1
answer
453
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 ...
- 121
0
votes
1
answer
377
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 ...
0
votes
2
answers
393
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 ...
- 111
0
votes
1
answer
645
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\...
0
votes
0
answers
1k
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 ...
- 431
0
votes
2
answers
11k
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 ...
- 13
1
vote
1
answer
675
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 ...
- 11
-1
votes
1
answer
916
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 ...
1
vote
0
answers
31
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 ...
4
votes
1
answer
883
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 ...
- 945
0
votes
4
answers
107
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 ...
- 109
2
votes
2
answers
759
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# ...
- 71
-1
votes
1
answer
551
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 ...
- 71
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 ...
silverbackbg
0
votes
1
answer
949
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 ...
- 217
2
votes
0
answers
713
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]...
- 121
1
vote
2
answers
49
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, ...
- 131
9
votes
1
answer
899
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 ...
- 93
0
votes
0
answers
900
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 ...
- 23
0
votes
1
answer
347
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 ...
- 15
2
votes
2
answers
3k
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 ...
- 252
3
votes
2
answers
263
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. ...
- 31
0
votes
3
answers
679
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 ...
1
vote
2
answers
88
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 ...
- 347
1
vote
1
answer
24
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 ...
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 ...
- 127
0
votes
1
answer
167
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 ...
- 195
2
votes
2
answers
16k
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 ‘...
- 195
0
votes
1
answer
83
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 ...
- 23
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 ...
- 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 ...
- 43
0
votes
0
answers
78
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 ...
1
vote
1
answer
251
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. ...
- 111
2
votes
1
answer
749
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 ...
user182143
18
votes
1
answer
75k
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 ...
- 309
1
vote
0
answers
891
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 ...
- 139
3
votes
1
answer
5k
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 ...
- 247
2
votes
1
answer
947
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 ...
- 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 ...
- 1