Hi,
We noticed that in our environment there is doubled very big backup of SQL.
It looks like each command tdpsqlc backup xxxx full/log/diff is performing backup twice.
From SQL level we can see that there are two restore points available.
When we are checking FS information there is second FS in below convention:
NodeName\data\0001
NodeName\data\0002
Of course 0002 shouldn't be existing.
When we are performing below command:
select FILESPACE_NAME, STATE, TYPE, HL_NAME, LL_NAME, BACKUP_DATE from backups where node_name='NodeName.SQL' and FILESPACE_ID='X' and HL_NAME like 'XXXX%'
We are receiving the same output for both Filespaces, even the time so it looks like backup is done once but sent to two FileSpaces.
From SQL Logs we can see few things which are not normal in our opinion:
1. Number of dump devices: 2
2. Type=VIRTUAL_DEVICE('TDPSQL-00003368-0000',TDPSQL-00003368-0001')
We have done below tests:
1. Backup was performed for TestDB to newly created node but it's the same situation.
2. SQL Dump was performed to local disk and only one .bak file was created.
Take a look in to below version information:
BA Version 7.1.6.5
TDPSQL 7.1.6.2 FlashCopyManager 4.1.6.2
Windows Server 2008 R2 x64
SQL Server 2008 SP4 - 10.0.6535.0
Did any one of you have this kind of situation? Or maybe you know where to search the reason of doubled FS during each backup.
We noticed that in our environment there is doubled very big backup of SQL.
It looks like each command tdpsqlc backup xxxx full/log/diff is performing backup twice.
From SQL level we can see that there are two restore points available.
When we are checking FS information there is second FS in below convention:
NodeName\data\0001
NodeName\data\0002
Of course 0002 shouldn't be existing.
When we are performing below command:
select FILESPACE_NAME, STATE, TYPE, HL_NAME, LL_NAME, BACKUP_DATE from backups where node_name='NodeName.SQL' and FILESPACE_ID='X' and HL_NAME like 'XXXX%'
We are receiving the same output for both Filespaces, even the time so it looks like backup is done once but sent to two FileSpaces.
From SQL Logs we can see few things which are not normal in our opinion:
1. Number of dump devices: 2
2. Type=VIRTUAL_DEVICE('TDPSQL-00003368-0000',TDPSQL-00003368-0001')
We have done below tests:
1. Backup was performed for TestDB to newly created node but it's the same situation.
2. SQL Dump was performed to local disk and only one .bak file was created.
Take a look in to below version information:
BA Version 7.1.6.5
TDPSQL 7.1.6.2 FlashCopyManager 4.1.6.2
Windows Server 2008 R2 x64
SQL Server 2008 SP4 - 10.0.6535.0
Did any one of you have this kind of situation? Or maybe you know where to search the reason of doubled FS during each backup.