All Questions
Tagged with sql-server-2017 restore
21 questions
0
votes
1
answer
84
views
SSISDB rename for maintenance
We have an SSISDB database that has become too large and we wanted to do some maintenance on it. I've read that you shouldn't rename the SSISDB database as it would break links to existing packages, ...
- 101
4
votes
1
answer
254
views
Unable to restore database with datetime2(0) in Partition Function
I have a SQL-Server database with large table that partition by a datetime2(2) column.
Some (old) filegroups marked as READ_ONLY.
Periodically I make the backup with READ_WRITE_FILEGROUPS option.
I ...
- 43
0
votes
0
answers
465
views
(Error : RESTORE HEADERONLY is terminating abnormally) when restoring SQL Backup from Standard edition to Developer Edition (Both 2017 Versions!)
The instances have the following versions
Source -->
Microsoft SQL Server 2017 (RTM-CU25) (KB5003830) - 14.0.3401.7 (X64)
Jun 25 2021 14:02:48 Copyright (C) 2017 Microsoft Corporation
Standard ...
15
votes
1
answer
22k
views
Clone a database from SQL Server 2019 to 2017 [duplicate]
I try to clone a database from an Sql Server on my local machine v15 (2019) to a server machine v14(2017). I did a .bak file and when I tried to import on the server side it says:
System.Data....
- 451
1
vote
3
answers
7k
views
Backup sqlserver 2019 and restore to Sqlserver 2017
I have only 1 table in SqlServer 2019 that I want to backup and restore into SqlServer 2017 in different server.
To SqlServer 2019 I have access to server and with SSMS but to SqlServer2017 I have ...
1
vote
1
answer
75
views
Can a transaction log backup create a new database before any full database backup is applied? SQL Server 2017
We have a large database we restore daily from a single t-log backup from a remote supplier. We are looking to move to 15 minute t-logs, but applying these to the current database on prem it is then ...
10
votes
2
answers
2k
views
Is it possible to restore a SQL Server Linux Backup on SQL Server Windows
I am running SQL Server in docker on a mac. I have taken a SQL Server backup from windows and restored it in the mac SQL Server docker instance. Now I want to take a backup from the SQL Server docker ...
- 333
0
votes
1
answer
214
views
SQL Server:Piecemeal Restore on Standard Edition 2017/2019?
I am currently fiddling with piecemeal restore.
I have some demo code from Jes Borland from her great presentation "Minimize Data Loss with Advanced Restore Methods" (take a look at https://www....
- 705
0
votes
1
answer
820
views
Piecemeal restore only one filegroup without primary filegroup restore
I have a db in SIMPLE recovery model, and regularly take FULL,DIFF backups.
This db also have filegroups for each month.
Each filegroup has exactly one NDF file.
Like this:
FileGroup: PRIMARY
File: ...
- 265
2
votes
2
answers
254
views
Log error restoring old database to SQL Server 2017
I am trying to migrate a database from an old SQL Server 2008 R2 to SQL Server 2017. The database was originally 2000 and thus has a compatibility level of 80. Initially I took a full database backup ...
- 21
2
votes
0
answers
834
views
SQL Server Restore Failing with Error Read on "M:\MSSQL\My_FULL_Backup_20190924_010558.bak" failed: 1101(A tape access reached a filemark
I have been trying to restore one of our db for the past few days without any luck. I keep getting the below error. I tried the restore during peak hours, off peak hours both by accessing the backup ...
- 335
13
votes
1
answer
2k
views
Temporarily moving a SQL Server 2016 database to SQL Server 2017 and then moving back. Is it possible?
If I take a backup of a database from a SQL Server 2016 instance and then restore it to a 2017 instance to do some work on it.
Can I then turn around and back up that database from the 2017 instance ...
- 241
3
votes
2
answers
915
views
How to query data in backups?
I have an ASP.NET app using SQL Server 2017. There's a bug somewhere that's causing some records to be deleted, and I'm trying to recover the data and find the cause of the bug. We take daily backups, ...
- 131
6
votes
4
answers
10k
views
Backup a database from Azure SQL Managed Instance and restore to on premise SQL Server
I have three databases that I am migrating to Azure SQL Managed Instance. One is a Utility database, just a small collection of generic functions and procedures. One is the OLTP database for a web ...
- 291
0
votes
1
answer
2k
views
SQL Server Agent Job - Unable to open Step output file. The step succeeded
I have seen many posts with "Unable to open Step output file.", but can't find any references where the step succeeded. I have my output file location set to:
$(ESCAPE_SQUOTE(SQLLOGDIR))\$(...
- 23
0
votes
0
answers
42
views
Log shipping - Secondary Server
I am not a SQL Server DBA but I need some advise. I am having a problem with a prod server that’s being pounded by constant queries and data mining. I have a second server that I would like to setup ...
- 1
-1
votes
1
answer
6k
views
Restore database - Operating system error 5(Access is denied.) on Linux
I try to restore SQL Server 2017 Express database using sqlcmd tool on Ubuntu 16 Server.
My SQL command is:
RESTORE DATABASE [xxxxx] FROM DISK = N'/home/xxxxxx/DBBackups/xxxx.bak' WITH NORECOVERY, ...
- 101
-1
votes
1
answer
177
views
Restoring AdventureWorks2014 Database to SQL Server 2017
I restored AdventureWorks2014 database from SQL Server 2014 to SQL Server 2017.
(I restored it twice, I changed the name on the 2nd restore, of course)
It works fine.
Now I tried to change the ...
- 1,350
1
vote
1
answer
480
views
SQLServer Linux: Error restoring backup of DB from Windows w/ full-text data file
I'm trying to move a Windows SQL Server database from Windows 10 to Linux.
For this, I'm following the instructions in
https://learn.microsoft.com/es-es/sql/linux/sql-server-linux-migrate-restore-...
user155183
2
votes
1
answer
164
views
How to ensure security with SQL Server Restore
I'm building a shared hosting SQL Server tool for linux, where users only receive access to their own database, with a SQL Login and SQL Database User that has db_datareader, db_datawriter and ...
- 131
5
votes
1
answer
608
views
What does sp_restore_filelistonly do?
In SQL Server 2017, after applying Cumulative Update 7, there's a new system stored procedure in master called sp_restore_filelistonly. What's it for?
- 43.2k