Comprehensive data protection for all workloads
Post Reply
frankive
Service Provider
Posts: 1092
Liked: 134 times
Joined: May 14, 2013 8:35 pm
Full Name: Frank Iversen
Location: Norway
Contact:

sql backup of logfiles

Post by frankive »

I have just setup a backupjob with a SQL-server.I
The job will copy the log files every 15 min.
Sql server is set to FULL on the databases and application aware processing with truncating is enabled.

My qeustion;
how do Veeam copy the files every 15 min.? Will it create a snapshot on my Hp Lefthand san or just just plain file copy from a share?
foggy
Veeam Software
Posts: 21139
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: sql backup of logfiles

Post by foggy » 1 person likes this post

Frank, please review how transaction logs backup works in detail. Hope this answers your question. Thanks.
frankive
Service Provider
Posts: 1092
Liked: 134 times
Joined: May 14, 2013 8:35 pm
Full Name: Frank Iversen
Location: Norway
Contact:

Re: sql backup of logfiles

Post by frankive »

Nice post. But how is the backup technically performed? will it create snapshot through our lefthand hardware provider?
foggy
Veeam Software
Posts: 21139
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: sql backup of logfiles

Post by foggy »

No snapshots are created. Veeam B&R just copies the log backup files backed up by native SQL Server log backup process (which does not use any snapshots either).
Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 48 guests