How can we help you today? How can we help you today?
JBaynham
Activity overview Badges (0) Posts (1) Comments (2)

Activity overview

Latest activity by JBaynham

Moving SQL Backup to new server with existing name
  1. Community
  2. SQL Backup
Hi,We plan to upgrade a 2016 SQL server to 2019, but not in place. The 2019 server is being built on a new box, which will be renamed to match the existing 2016 server name (which will also have be...
1 follower 1 comment 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
  1. Community
  2. SQL Backup
  3. Problem with restores
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
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
  1. Community
  2. SQL Backup
  3. Problem with restores
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
Total activity
4
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1