August 30, 2011 at 2:16 am
My environment:
SQL Server 2008 standard Edition 32bit on Windows Server 2008 Standard Edition 32bit.
The server is hosted by one ESXi node.
Backup strategy:
Full backup every day at 09.00 PM
Differential backup every day every 2 hours between 05.10 AM until 09.10 PM
Log backup every day every 15 minutes between 05.05 AM until 08.05 PM
Theses backup files are then backed up on Tape during the night.
I know that the VMWare's administrator has implemented VEEAM Backup in order to take snapshots of this server but I have noticed something strange:
I have noticed a new messages in SQL Server errorlog exactly at the moment when Veeam takes the backup:
I/O is frozen on database model. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup.
I/O is frozen on database msdb. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup.
I/O is frozen on database master. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup.
I/O is frozen on database xxxxxx. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup.
and then
I/O was resumed on database master. No user action is required.
...
...
So there are no errors but at least something is strange to me.
I also noticed that the backup performed with Veeam writes information in msdb database.
i.e.
The table msdb.dbo.backupset contain records with this kind of informations:
is_snapshot = 1
is_copy_only = 1
The table msdb.dbo.backupmediafamily contain strange information in some fileds:
- for sql native backup I have a situation like this:
physical_device_name = C:\Folder\subfoder\db_xx_xxxx_FULL_20110809_213000.bak
device_type = 2
physical_block_size = 512
- for Veeam backup I have this one:
physical_device_name = {9D96FB8D-87FA-4B5B-9FC3-CEA7158FE10B}4
device_type = 7
physical_block_size = 1024
What is your suggestions for this kind of a situation?
My concern is about the fact that Veeam writes strange information in msdb database.
Could you please give me a feedback?
Thank you very much.
Best regards.
Franco
August 30, 2011 at 5:59 am
what version of ESX are you using?
I've not used Veem have you tried asking on their forum
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 30, 2011 at 7:59 am
Perry Whittle (8/30/2011)
what version of ESX are you using?
4.0
I've not used Veem have you tried asking on their forum
already done, I am waiting for a reply.
Thank you.
Franco
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply