Discussions specific to the VMware vSphere hypervisor
Post Reply
tom11011
Expert
Posts: 142
Liked: 2 times
Joined: Dec 01, 2010 8:40 pm
Full Name: Tom
Contact:

receiving a database error popup while backing up vm

Post by tom11011 » Feb 06, 2013 5:50 pm

Hi Group,

I'm receiving a popup message during backup of a particular virtual machine. The backup does complete, but the stats in the backup job seem to freeze during the backup. Although the backup does finish.

"failed to retrieve updated or changed rows from the table reportsessionview. usn:0 unexpected end of file has occured."

The backup server seems to crawl when viewing it with remote desktop at this point until the backup finishes.

dellock6
Veeam Software
Posts: 5734
Liked: 1625 times
Joined: Jul 26, 2009 3:39 pm
Full Name: Luca Dell'Oca
Location: Varese, Italy
Contact:

Re: receiving a database error popup while backing up vm

Post by dellock6 » Feb 06, 2013 6:05 pm

Are you using SQL Express database directly installed on the Veeam backup server? I've seen many different errors, with obscure and weird messages, but all of them were caused at the end by lack on RAM on the server hosting the Veeam database, especially when it's on the same machine with Veeam itself.
Depending on the size of the environment, consider adding more RAM to the server, or switch to SQL Server standard.

Luca.
Luca Dell'Oca
Principal EMEA Cloud Architect @ Veeam Software

@dellock6
https://www.virtualtothecore.com/
vExpert 2011 -> 2019
Veeam VMCE #1

tom11011
Expert
Posts: 142
Liked: 2 times
Joined: Dec 01, 2010 8:40 pm
Full Name: Tom
Contact:

Re: receiving a database error popup while backing up vm

Post by tom11011 » Feb 06, 2013 6:38 pm

Yes, it is sqlexpress installed locally to the veeam server. However, this server has 16gigs of memory installed running Win2k8 R2 so I don't think that could be the problem?

Vitaliy S.
Product Manager
Posts: 23001
Liked: 1557 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: receiving a database error popup while backing up vm

Post by Vitaliy S. » Feb 06, 2013 6:43 pm

As far as I know SQL Server Express always had a limit of max supported RAM, for example, SQL Server Express 2008 R2 only supports from 1 to 4 GBs max.

tom11011
Expert
Posts: 142
Liked: 2 times
Joined: Dec 01, 2010 8:40 pm
Full Name: Tom
Contact:

Re: receiving a database error popup while backing up vm

Post by tom11011 » Feb 06, 2013 6:54 pm

I'm going to take that back. It seems all 16gigs were maxed out. When I logged off the rdp console and then logged back in and opened veeam, memory consumption was down to 2 gigs. Something must be leaking memory somewhere on the server.

Thanks for your reply.

dellock6
Veeam Software
Posts: 5734
Liked: 1625 times
Joined: Jul 26, 2009 3:39 pm
Full Name: Luca Dell'Oca
Location: Varese, Italy
Contact:

Re: receiving a database error popup while backing up vm

Post by dellock6 » Feb 06, 2013 9:44 pm

Is this server also your repository (usually when you install Veeam BR all in one server)? Then it could also be memory consumption by Windows to open and manage pretty large VBK files, for example in reverse incremental backup jobs. I wrote something about this behaviour here:
http://www.vuemuer.it/en/?p=4064
even if it would not be your problem, rammap can help you to investigate who is consuming the server memory.

Luca.
Luca Dell'Oca
Principal EMEA Cloud Architect @ Veeam Software

@dellock6
https://www.virtualtothecore.com/
vExpert 2011 -> 2019
Veeam VMCE #1

tom11011
Expert
Posts: 142
Liked: 2 times
Joined: Dec 01, 2010 8:40 pm
Full Name: Tom
Contact:

Re: receiving a database error popup while backing up vm

Post by tom11011 » Feb 12, 2013 3:33 am

yes, it is the repository server and we do use reverse incrementals. I'll have a look at your link.

Post Reply

Who is online

Users browsing this forum: No registered users and 16 guests