May 4, 2024 at 3:31 pm
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory oltp enabled. I have a full and a diff backup I'm trying to restore under a new database name, followed by some log files. The full restores fine but then the diff throws this error and I can't find anything about this:
Msg 3634, Level 16, State 1, Line 29
The operating system returned the error '(null)' while attempting 'DeleteFile' on 'M:\sqldata\DBname_Memory\filestream.hdr'.
Msg 3013, Level 16, State 1, Line 29
RESTORE DATABASE is terminating abnormally.
The full restores and moves the files to the locations I want. Here is the diff restore text.
RESTORE DATABASE [MYDB_new]
FROM DISK = N'X:\tempsqlbackups\Path\DBName\DIFF\DBName_DIFF_20240504_110828.bak'
WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 5;
GO
What is strange is that I have been able to restore this diff before. I'm doing this process again with these files because I made a mistake and recovered the database too early when I was applying log backups during a previous attempt.
I'm taking a new DIFF backup now to see if that one will restore.
May 4, 2024 at 4:22 pm
I apparently had the wrong filename when I tried the diff the next time. It failed saying it couldn't find the filename. I corrected that and tried again and then got this, so I've dropped the DB_New database and I'll start the process over for the 3rd time now. I'm taking a new full backup and I already have log backups of the source database going to a the same local drive for now so I can just pick back up with log restores.
I get one of these messages for each logical file in the database.
Msg 4319, Level 16, State 2, Line 29
A previous restore operation was interrupted and did not complete processing on file 'DBLogicalFileName'. Either restore the backup set that was interrupted or restart the restore sequence.
May 4, 2024 at 9:15 pm
This is a database with a filestream file group?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 5, 2024 at 11:30 pm
No. There is no separate filegroup for filestream.
May 8, 2024 at 10:20 am
restore the filelist from the backup and report the files found
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply