09-24-2019 02:23 AM
Hello,
We get errors during chain restore FULL --> DIFF --> transaction log, but FULL --> DIFF works fine.
Log accaount - sysadmin
Source DB with FULL recovery model
Advanced open file option disabled
Allow OFFLINE true
Restore to New DBs, NEW servers (same error)
----------------
SQL SERVER log:
no errors and in monitor i see only one process, like
RESTORE LOG [DB_dev] FROM virtual_device = 'DB_dev_00__315e514f_baf0_4e17_b1fb_4d559f3822bd_' WITH NORECOVERY (SUSPENDED)
----------------
RAWS log
- SQL Error Source: Microsoft SQL Server Native Client 11.0
- SQL Server database in RESTORING state
- SQL Error State: 42000
- SQL Error Number: 927
- Check for active snapshot restore process left hanging to complete
- Checking for active snapshot MSSQLSERVER\DB_dev
- No snapshot object found. No active snapshot restore in progress (but i see RESTORE LOG process in management studio)
- SQL2_StartCommand = RESTORE DATABASE [DB_dev] WITH RECOVERY
- SQL Error GUID: 3ede860
- SQL Error Source: Microsoft SQL Server Native Client 11.0
- SQL Error Description: RESTORE DATABASE canceled with error.
- SQL Error State: 42000
- SQL Error Number: 3013
- SQL Error GUID: 3ede860
- SQL Error Source: Microsoft SQL Server Native Client 11.0
- SQL Error Description: "Exclusive access could not be obtained because the database is in use." (only one veritas process)
- SQL Error State: 42000
- SQL Error Number: 3101
JOB messages
V-79-57344-65072 - The connection to target system has been lost.
V-79-57344-38051 - An error occurred while attempting to recover the database
---------------
Any idea?
09-24-2019 03:23 AM - edited 09-24-2019 03:51 AM
App LOG before error
VSS is shutting down due to downtime.
SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=4056. Thread=13364. Client. Instance=MSSQLSERVER. VD=Global\DB_dev_00__315e514f_baf0_4e17_b1fb_4d559f3822bd__SQLVDIMemoryName_0.