log shipping excludes some database

VMware specific discussions

log shipping excludes some database

Veeam Logoby sirhideo » Sat Mar 21, 2015 3:32 am

I have turned on AAIP for my mssql 2012 server and have log shipping every 15 mins. Inside the server I have ReportServer, WSUS and VeeamBackup database.

When I look at the sql report it shows myinstance\model and ReportServer$Instance is protected. master, msdb and SUSDB is excluded. VeeamBackup database isn't even on the list.

Besides recovery model set to full and have the account run as sysadmin, is there anything else I have setup ? I expected to have them all protected.
sirhideo
Enthusiast
 
Posts: 49
Liked: 3 times
Joined: Mon Feb 02, 2015 9:17 am
Full Name: Frankie

Re: log shipping excludes some database

Veeam Logoby Vitaliy S. » Sat Mar 21, 2015 12:08 pm

HI Frankie,

Do you see these databases as excluded or unprotected? See our user guide clarification about reasons for exclusions:
Excluded — databases excluded from processing. This may be due to any of the following reasons: database status is Offline, database recovery model is set to Simple, database is read-only, database was deleted after the latest full backup, registry key value (list of exclusions). To learn more about the list of exclusions, see http://www.veeam.com/kb1051.

Let me know if that helps!
Vitaliy S.
Veeam Software
 
Posts: 19545
Liked: 1099 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: log shipping excludes some database

Veeam Logoby sirhideo » Sat Mar 21, 2015 6:58 pm

Hi Vitaliy

After checking those db settings I have them almost protect except:

1) INSTANCE\master : Failed to perform internal backup (INSTANCE\master): Code = 0x80040e14 Code meaning = IDispatch error #3092 Source = Microsoft OLE DB Provider for SQL Server Description = Cannot back up the log of the master database. Use BACKUP DATABASE instead. COM error: Code: 0x80040e14

2) VeeamBackup DB still isn't on the database list, is it by default ignored by VeeamB&R?

Thanks
sirhideo
Enthusiast
 
Posts: 49
Liked: 3 times
Joined: Mon Feb 02, 2015 9:17 am
Full Name: Frankie

Re: log shipping excludes some database

Veeam Logoby Vitaliy S. » Sat Mar 21, 2015 7:28 pm

By default Veeam B&R database is set to simple mode, did you change it to full recovery mode manually?
Vitaliy S.
Veeam Software
 
Posts: 19545
Liked: 1099 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: log shipping excludes some database

Veeam Logoby sirhideo » Sun Mar 22, 2015 3:13 am

Vitaliy S. wrote:By default Veeam B&R database is set to simple mode, did you change it to full recovery mode manually?


Yes, I have set it to full already.

But even VeeamBackup db is in simple mode, at least during log shipping veeam B&R should exclude it right?

VeeamBackup db doesn't even appear in the SQL report. It looks to me that it is totally ignored by veeam B&R.

DB that hosted in my sql server
Image

VeeamBackup isn't on the report
Image

How about the master database error message, is it something related to Veeam?

The transaction message is as follow:

3/22/2015 11:14:44 AM :: Saving transaction logs backup file to repository (INSTANCE\SUSDB; INSTANCE\ReportServer$INSTANCETempDB; INSTANCE\ReportServer$INSTANCE; INSTANCE\msdb; INSTANCE\model)

Property of VeeamBackup database:
Image


Thanks
sirhideo
Enthusiast
 
Posts: 49
Liked: 3 times
Joined: Mon Feb 02, 2015 9:17 am
Full Name: Frankie

Re: log shipping excludes some database

Veeam Logoby Vitaliy S. » Sun Mar 22, 2015 5:16 pm

Based on what I know, Veeam backup database should not be excluded, but I will double check tomorrow. On a side note, do you have this key specified by any chance?

Do you have any error events in the Windows event log regarding SQL database backup and master db?
Vitaliy S.
Veeam Software
 
Posts: 19545
Liked: 1099 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: log shipping excludes some database

Veeam Logoby sirhideo » Mon Mar 23, 2015 7:59 am

No, I don't have the said regkey on my Veeam server.

I will double check the event log of my sql later today.

Got something new tho... as you can see above msdb and model is being protected. However, on SQL explorer I don't see the DB. Only both ReportServers and SUSDB can be restore, permission issue again?
sirhideo
Enthusiast
 
Posts: 49
Liked: 3 times
Joined: Mon Feb 02, 2015 9:17 am
Full Name: Frankie

Re: log shipping excludes some database

Veeam Logoby Vitaliy S. » Mon Mar 23, 2015 9:06 am

System databases are not displayed in the Explorer UI, see this topic for more details > Where are Master, Model, MSDB in SQL Item Restore
Vitaliy S.
Veeam Software
 
Posts: 19545
Liked: 1099 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: log shipping excludes some database

Veeam Logoby Vitaliy S. » Mon Mar 23, 2015 9:33 am

...and as to Veeam backup database, then it is excluded from AAIP process by default, that is why you can't see this database in the Explorer UI. The recommended way of backing up and restoring our database should be done via built-in Configuration backup tool.
Vitaliy S.
Veeam Software
 
Posts: 19545
Liked: 1099 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: log shipping excludes some database

Veeam Logoby sirhideo » Mon Mar 23, 2015 10:34 am

Vitaliy S. wrote:...and as to Veeam backup database, then it is excluded from AAIP process by default, that is why you can't see this database in the Explorer UI. The recommended way of backing up and restoring our database should be done via built-in Configuration backup tool.

Good to know that, thanks. I will follow up the master db error message and give an update here.
sirhideo
Enthusiast
 
Posts: 49
Liked: 3 times
Joined: Mon Feb 02, 2015 9:17 am
Full Name: Frankie

Re: log shipping excludes some database

Veeam Logoby PatrikPriess » Thu Apr 23, 2015 7:35 am

Hi Sirhideo

Just tested on our SQL 2014 and have exact same issue on the master database.

Failed to perform internal backup (master): Code = 0x80040e14 Code meaning = IDispatch error #3092 Source = Microsoft OLE DB Provider for SQL Server Description = Cannot back up the log of the master database. Use BACKUP DATABASE instead. COM error: Code: 0x80040e14

Should this not be excluded by default ?

Did you have any update ?
PatrikPriess
Service Provider
 
Posts: 5
Liked: never
Joined: Wed Nov 12, 2014 10:37 am
Full Name: Patrik Priess

Re: log shipping excludes some database

Veeam Logoby PatrikPriess » Thu Apr 23, 2015 8:00 am

Just gonna quote my self. Our DBA had placed the master databse in "Full" loggin mode. Thats why is wasent excluded.
So pr default my guess is that Veeam exclude all DB's thats in singel mode :)

/Patrik
PatrikPriess
Service Provider
 
Posts: 5
Liked: never
Joined: Wed Nov 12, 2014 10:37 am
Full Name: Patrik Priess

Re: log shipping excludes some database

Veeam Logoby Gostev » Fri Apr 24, 2015 12:54 am

Correct, as databases using simple recovery model do not maintain transaction logs, so there is nothing for us to backup.
Gostev
Veeam Software
 
Posts: 21390
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

[MERGED]: SQL Restore now log shipping is failing

Veeam Logoby leo.white » Fri Nov 20, 2015 3:10 pm

I been testing the SQL backup for veeam. I am on 8.0 with the latest update. I was able to do a point in time restore on one of my databases, but ever since i did that i been getting log errors saying that database is excluded. At the same time that database shows up again and is not excluded? I have rebooted both the Veeam Server and the SQL server. Still getting errors. When i look at the SQL server i only see one instance of the Database. Anyone seen this before?
leo.white
Influencer
 
Posts: 21
Liked: 1 time
Joined: Wed Jul 23, 2014 7:05 pm

Re: log shipping excludes some database

Veeam Logoby PTide » Fri Nov 20, 2015 3:26 pm

Hi Leo,

Please check which recovery model does your DB use. If it's "Full" then please open a ticket with support and post your case ID here.

Thank you.
PTide
Veeam Software
 
Posts: 3019
Liked: 246 times
Joined: Tue May 19, 2015 1:46 pm

Next

Return to VMware vSphere



Who is online

Users browsing this forum: Dschano, Google [Bot] and 28 guests