Veeam Endpoint Backup: error in SQL Server logs, why?

Backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)

Veeam Endpoint Backup: error in SQL Server logs, why?

Veeam Logoby xpg934 » Fri Feb 10, 2017 2:39 pm

Hello.

I use Veeam Endpoint Backup FREE to backup files (file level backup).
Also this physical Windows Server has SQL Server installed, but sql-databases are not handled with Veeam.
Thus, each run Veeam I get errors in SQL Server log (Veeam backup is started at 04:00):
Code: Select all
02/10/2017 04:01:57,Backup,Unknown,BACKUP failed to complete the command BACKUP LOG model. Check the backup application log for detailed messages.
02/10/2017 04:01:57,Backup,Unknown,Error: 3041 Severity: 16 State: 1.
02/10/2017 04:01:04,Backup,Unknown,Database backed up. Database: MyDataBase creation date(time): 2014/03/13(15:52:54) pages dumped: 17025661 first LSN: 1436777:4468:181 last LSN: 1436777:4542:1 number of dump devices: 1 device information: (FILE=1 TYPE=VIRTUAL_DEVICE: {'{042CC01D-A9C4-4810-8209-F083581FA2F1}1'}). This is an informational message only. No user action is required.
02/10/2017 04:01:02,spid53,Unknown,I/O was resumed on database MyDataBase. No user action is required.
02/10/2017 04:01:02,spid53,Unknown,I/O is frozen on database MyDataBase. No user action is required. However if I/O is not resumed promptly you could cancel the backup.

Why Veeam is do something with SQL Server? (it tried to backup database to vitrual device... database size is > 200Gb and always used by clients)
How I can turn off this? we need only file level backup, not sql server databases and so on.
xpg934
Influencer
 
Posts: 12
Liked: never
Joined: Fri Feb 10, 2017 2:15 pm
Full Name: Alexey Trizno

Re: Veeam Endpoint Backup: error in SQL Server logs, why?

Veeam Logoby Dima P. » Fri Feb 10, 2017 2:46 pm

Hi Alexey,

Did you include SQL database location via file level backup? If yes, try to exclude it from the backup and re run the job.
Dima P.
Veeam Software
 
Posts: 6517
Liked: 454 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Veeam Endpoint Backup: error in SQL Server logs, why?

Veeam Logoby xpg934 » Fri Feb 10, 2017 3:14 pm

Yes, real databases are located at D:\database\*, and backed up files at D:\database\backup\*

Thank you, I'll try.
xpg934
Influencer
 
Posts: 12
Liked: never
Joined: Fri Feb 10, 2017 2:15 pm
Full Name: Alexey Trizno

Re: Veeam Endpoint Backup: error in SQL Server logs, why?

Veeam Logoby Dima P. » Fri Feb 10, 2017 11:37 pm

Alexey,

Great. Keep us posted!

P.S. Veeam Agent for Windows 2.0 Beta is live, so if you want to test SQL backup functionality - here is a link :wink:
Dima P.
Veeam Software
 
Posts: 6517
Liked: 454 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Veeam Endpoint Backup: error in SQL Server logs, why?

Veeam Logoby xpg934 » Mon Feb 13, 2017 9:33 am

Now I try to backup files from the path:

D:\database.backup\mydb.bak

Working SQL Server databases are located at:

D:\database\*

But nothing changed. SQL Server log files again contains these lines:

Code: Select all
02/13/2017 03:34:31,Backup,Unknown,BACKUP failed to complete the command BACKUP LOG model. Check the backup application log for detailed messages.
02/13/2017 03:34:31,Backup,Unknown,Error: 3041 Severity: 16 State: 1.
02/13/2017 03:00:52,Backup,Unknown,Database backed up. Database: MyDatabase creation date(time): 2014/03/13(15:52:54) pages dumped: 17055027 first LSN: 1447010:3251:89 last LSN: 1447010:3288:1 number of dump devices: 1 device information: (FILE=1 TYPE=VIRTUAL_DEVICE: {'{7DFBCFB0-1369-4ED8-8469-1282AC723CF8}1'}). This is an informational message only. No user action is required.
02/13/2017 03:00:51,spid56,Unknown,I/O was resumed on database MyDatabase. No user action is required.
02/13/2017 03:00:51,spid56,Unknown,I/O is frozen on database MyDatabase. No user action is required. However if I/O is not resumed promptly you could cancel the backup.


Why? And again backup of files is failed :(
How I can disable SQL Server interaction in any case?
xpg934
Influencer
 
Posts: 12
Liked: never
Joined: Fri Feb 10, 2017 2:15 pm
Full Name: Alexey Trizno

Re: Veeam Endpoint Backup: error in SQL Server logs, why?

Veeam Logoby Dima P. » Mon Feb 13, 2017 5:44 pm

Alexey,

May I ask you to install the VAW 2.0 BETA (the link above should work)? Certain fixes were implemented in the latest version and your scenario should be supported. Kindly, check if new version works for your case and let us know.
Dima P.
Veeam Software
 
Posts: 6517
Liked: 454 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Veeam Endpoint Backup: error in SQL Server logs, why?

Veeam Logoby xpg934 » Mon Feb 13, 2017 5:49 pm

I've already installed 2.0 beta. But nothing changed :(
xpg934
Influencer
 
Posts: 12
Liked: never
Joined: Fri Feb 10, 2017 2:15 pm
Full Name: Alexey Trizno

Re: Veeam Endpoint Backup: error in SQL Server logs, why?

Veeam Logoby xpg934 » Mon Feb 13, 2017 5:58 pm

Uups, sorry. On this server 1.5 version is still installed.
Now I've installed 2.0 beta. Tomorrow we'll see how it goes backup.

Maybe Agent has somewhere the debug log?
xpg934
Influencer
 
Posts: 12
Liked: never
Joined: Fri Feb 10, 2017 2:15 pm
Full Name: Alexey Trizno

Re: Veeam Endpoint Backup: error in SQL Server logs, why?

Veeam Logoby Dima P. » Mon Feb 13, 2017 10:37 pm

Alexey,

Sure. C:\ProgramData\Veeam\Endpoint\

Let us know how it goes.
Dima P.
Veeam Software
 
Posts: 6517
Liked: 454 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Veeam Endpoint Backup: error in SQL Server logs, why?

Veeam Logoby xpg934 » Tue Feb 14, 2017 12:52 pm

Dmitry, is better now. No errors in SQL Server log.
However, Veeam still do backup databases, for some reason.
How to turn off it?
Backup of databases is performed in a different time and not with Veeam.

Code: Select all
02/14/2017 03:01:09,Backup,Unknown,Database backed up. Database: MyDatabase creation date(time): 2014/03/13(15:52:54) pages dumped: 17069322 first LSN: 1447321:449:38 last LSN: 1447321:466:1 number of dump devices: 1 device information: (FILE=1 TYPE=VIRTUAL_DEVICE: {'{E37F68F2-06F0-4270-9EBB-F3A57A0E106D}1'}). This is an informational message only. No user action is required.
02/14/2017 03:01:07,spid54,Unknown,I/O was resumed on database MyDatabase. No user action is required.
02/14/2017 03:01:07,spid54,Unknown,I/O is frozen on database MyDatabase. No user action is required. However if I/O is not resumed promptly you could cancel the backup.
xpg934
Influencer
 
Posts: 12
Liked: never
Joined: Fri Feb 10, 2017 2:15 pm
Full Name: Alexey Trizno

Re: Veeam Endpoint Backup: error in SQL Server logs, why?

Veeam Logoby Dima P. » Wed Feb 15, 2017 10:41 pm

Alexey,

Do you have application aware processing enabled in VAW job settings?
Dima P.
Veeam Software
 
Posts: 6517
Liked: 454 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Veeam Endpoint Backup: error in SQL Server logs, why?

Veeam Logoby xpg934 » Thu Feb 16, 2017 5:22 am

Dmitry,

No, this setting is not enabled:

Destination --------------------------------------
Shared folder: \\....\backups\
Keep restore points for the last 7 cycles
Compression level: Optimal (recommended)
Storage optimization: LAN target
Storage encryption: disabled


Backup cache -------------------------------------
Backup cache is disabled


Guest processing ---------------------------------
Application-aware processing: [disabled]

Guest file system indexing: [disabled]

Script processing: [disabled]


Schedule -----------------------------------------
Schedule: server
Daily at [3:00]
Retry failed job every 3 time(s)
Wait before each retry attempt for: 10 minute(s)
Create active full backups on Monday
xpg934
Influencer
 
Posts: 12
Liked: never
Joined: Fri Feb 10, 2017 2:15 pm
Full Name: Alexey Trizno

Re: Veeam Endpoint Backup: error in SQL Server logs, why?

Veeam Logoby xpg934 » Sat Feb 18, 2017 9:41 pm

Dmitry,

Even if I configure VAW as in the screenshot (perform copy only) - nothing changes, there's always backup the sql server database when VAW starts sheduled backup of files.
Why VAW makes a backup of all active sql databases on the server?

Image
xpg934
Influencer
 
Posts: 12
Liked: never
Joined: Fri Feb 10, 2017 2:15 pm
Full Name: Alexey Trizno

Re: Veeam Endpoint Backup: error in SQL Server logs, why?

Veeam Logoby xpg934 » Wed Feb 22, 2017 2:25 pm

Is there any news on this problem?
xpg934
Influencer
 
Posts: 12
Liked: never
Joined: Fri Feb 10, 2017 2:15 pm
Full Name: Alexey Trizno

Re: Veeam Endpoint Backup: error in SQL Server logs, why?

Veeam Logoby jmmarton » Wed Feb 22, 2017 2:45 pm

With the screenshot you posted, we will indeed backup the database. With AAIP enabled we'll leverage VSS writers for any application which has VSS writers enabled. The "copy only" setting only impacts the transaction logs. With that setting we'll take a completely application-consistent backup but we won't truncate the transaction logs.

Joe
jmmarton
Veeam Software
 
Posts: 892
Liked: 95 times
Joined: Tue Nov 17, 2015 2:38 am
Location: Chicago, IL
Full Name: Joe Marton

Next

Return to Veeam Agent for Windows



Who is online

Users browsing this forum: Yahoo [Bot] and 11 guests