I am curious on some professional opinions and suggestions for my SQL Server backups.
Currently, I have a client that is using some software called Shadow Protect which backups his entire Terminal Server. I assume it is a Volume Shadow Copy type of backup not a file based backup.
Here is my concern. I am noting some data integrity issues because in the SQL Logs I see log entries like this:
03/17/2014 08:00:32,Backup,Unknown,Database backed up. Database: MYDB<c/> creation date(time): 2014/03/13(20:49:14)<c/> pages dumped: 217610<c/> first LSN: 1191:305:64<c/> last LSN: 1191:333:1<c/> number of dump devices: 1<c/>
device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'{5E27CA5B-DEEA-45C9-9E6A-43DFCC0522B6}7'}). This is an informational message only. No user action is required.
Which based on my readings freezing of the entire SQL Server is a bad idea and not ideal. Curr ...
Go to the complete details ...