Avamar: SQL-differentiel sikkerhedskopiering fuldføres med undtagelsen "Kunne ikke finde den differential_base_lsn værdi i metadatafilen"

Summary: Avamar: SQL-plug-in – SQL-differentiel sikkerhedskopiering fuldføres med undtagelse af "Kunne ikke finde den differential_base_lsn værdi i metadatafilen."

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

Avamar SQL Plug-in-sikkerhedskopieringsloggen viser følgende linjer for differential-sikkerhedskopieringen.

2018-06-06 11:13:39 avsql Warning <17378>: Private properties of resouce could not be resolved for Name.
2018-06-06 11:13:45 avsql Warning <43543>: Couldn't find the differential_base_lsn value in the metadata file. 
Due to the changes in this plugin version, it is recommended to take a FULL backup for the database '<sql-db-name>'.

Ovenstående advarsel dukkede op, fordi plugin-sikkerhedskopiering efterlod "Differential_base_lsn" -værdier som tomme, når forskellige logiske navne registreres for den samme database. For at kontrollere logiske navne" skal du køre SQL-forespørgsel:

SELECT d.name AS DatabaseName,
       f.name AS LogicalName,
       f.physical_name AS PhysicalName,
       f.type_desc AS TypeofFile
FROM sys.master_files f
INNER JOIN sys.databases d ON d.database_id = f.database_id;

Here are the results:

DatabaseName	LogicalName	PhysicalName	TypeofFile
master		master	C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\master.mdf	ROWS
master		mastlog	C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\mastlog.ldf	LOG
tempdb		tempdev	C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\tempdb.mdf	ROWS
tempdb		templog	C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\templog.ldf	LOG
model		modeldev	C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\model.mdf	ROWS
model		modellog	C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\modellog.ldf	LOG
msdb		MSDBData	C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf	ROWS
msdb		MSDBLog	C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\MSDBLog.ldf	LOG
db_1		DB_1	C:\SQL_AG_2\DB_1.mdf	ROWS
db_1		DB_1_log	C:\SQL_AG_2\DB_1_log.ldf	LOG
db1_2020	DB_1	C:\Recovery\db1_2020_data_0.mdf	ROWS
db1_2020	DB_1_log	C:\Recovery\db1_2020_log_0.ldf	LOG
feb13_restore	DB_1	C:\SQL_AG_2\feb13_restore_data_0.mdf	ROWS
feb13_restore	DB_1_log	C:\SQL_AG_2\feb13_restore_log_0.ldf	LOG
db_1_1		DB_1	C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\file	ROWS

 

Cause

"Differential_base_lsn"-værdier er tomme, når der findes forskellige logiske navne for en database.
Ovenstående advarselsmeddelelse medfører, at sikkerhedskopieringen fuldføres med en undtagelse, men sikkerhedskopieringen er gyldig og kan gendannes fuldt ud. Problemet er løst ved ændringen i pluginkoden, så den ikke er afhængig af logiske navne på databasen.

 

Resolution

Advarslen kan ignoreres uden problemer.
Du kan også kontakte Avamar-support for at få et plugin-hotfix, hvor det kosmetiske problem er blevet løst fuldt ud.

 

Affected Products

Avamar

Products

Avamar, Avamar Plug-in for SQL
Article Properties
Article Number: 000163315
Article Type: Solution
Last Modified: 28 Oct 2025
Version:  6
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.