User profile for JBaynham – Support

Activity overview Badges (0) Posts (1) Comments (2)

Comments

Full errors and warnings section of log: ERRORS AND WARNINGS 15/12/2017 12:09:54: Restoring Twitter_Verification (transaction logs) from: 15/12/2017 12:09:54: d:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Backup\LOG_(local)_Twitter_20171215_113103.sqb 15/12/2017 12:09:54: RESTORE LOG [Twitter_Verification] FROM VIRTUAL_DEVICE = 'SQLBACKUP_75CF1613-98F2-4D6F-B4EA-92DFEAFD30BA', VIRTUAL_DEVICE = 'SQLBACKUP_75CF1613-98F2-4D6F-B4EA-92DFEAFD30BA01', VIRTUAL_DEVICE = 'SQLBACKUP_75CF1613-98F2-4D6F-B4EA-92DFEA FD30BA02' WITH BUFFERCOUNT = 18, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , RECOVERY, MOVE 'ADImport' TO 'd:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\Twitter_Verification_ADImport.mdf', MOVE 'ADImport_log' TO 'd:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Data\Twitter_Verification_ADImport_log.ldf', REPLACE 15/12/2017 12:09:54: Thread 0 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) 15/12/2017 12:09:54: 15/12/2017 12:09:54: Thread 1 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) 15/12/2017 12:09:54: 15/12/2017 12:09:54: Thread 2 error: Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.) 15/12/2017 12:09:54: 15/12/2017 12:09:54: SQL error 3013: RESTORE LOG is terminating abnormally. 15/12/2017 12:09:54: SQL error 4330: This backup set cannot be applied because it is on a recovery path that is inconsistent with the database. The recovery path is the sequence of data and log backups that have brought the database to a particular recovery point. Find a compatible backup to restore, or restore the rest of the database to match a recovery point within this backup set, which will restore the database to a different point in time. For more information about recovery paths, see SQL Server Books Online. / comments

Full errors and warnings section of log: ERRORS AND WARNINGS 15/12/2017 12:09:54: Restoring Twitter_Verification (transaction logs) from: 15/12/2017 12:09:54: d:\Program Files\Microsoft SQL Serv...

0 votes

Thanks Eddie, I had been fiddling about with the recovery models of these databases to provide a variety of scenarios as part of my trial. All looks good now. / comments

Thanks Eddie, I had been fiddling about with the recovery models of these databases to provide a variety of scenarios as part of my trial. All looks good now.

0 votes

Total activity: 4
Last activity: February 06, 2025 11:55
Member since: February 06, 2025 06:50

Following: 0 users
Followed by: 0 users
Votes: 0
Subscriptions: 1