SQL truncate - removed instance now gives warning

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

SQL truncate - removed instance now gives warning

Veeam Logoby bucoops » Mon Jul 31, 2017 8:24 am

Good Morning,

we're using windows agent while I bide my time to be able to spend some money to virtualise our last server. It's a bit of a do-all server in that it has exchange, mailmarshall, webmarshall, sophos enerprise console and a few other bits and pieces.

I found there was a SQL Express 2005 instance of Blackberry Enterprise Server which the software for was long ago uninstalled, so I have removed that instance - and now Veeam agent gives a warning:

Unable to truncate SQL server transaction logs. Details: Failed to enumerate SQL instance on host. Failed to retrieve the configuration parameters of the [BAS-AS] service. Win32 error:The system cannot find the file specified. Code: 2

Any idea how I can stop Veeam trying to talk to this instance without breaking the other EIGHT instances? I presume I can remove the backup config and build a new one but would prefer not to if possible.

thanks
bucoops
Enthusiast
 
Posts: 38
Liked: 1 time
Joined: Mon Aug 01, 2016 6:37 pm
Full Name: Richard

Re: SQL truncate - removed instance now gives warning

Veeam Logoby Dima P. » Mon Jul 31, 2017 5:27 pm

Hi Richard,

Can you run an active full backup for this server and check if this warning persists? Thanks!
Dima P.
Veeam Software
 
Posts: 6387
Liked: 449 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL truncate - removed instance now gives warning

Veeam Logoby bucoops » Mon Jul 31, 2017 5:49 pm

Hi Dima, I did a standalone one and that didn't do anything (before starting thread), trying an active full now.
bucoops
Enthusiast
 
Posts: 38
Liked: 1 time
Joined: Mon Aug 01, 2016 6:37 pm
Full Name: Richard

Re: SQL truncate - removed instance now gives warning

Veeam Logoby bucoops » Mon Jul 31, 2017 7:01 pm

Nope, same issue :(

Unable to truncate SQL server transaction logs. Details: Failed to enumerate SQL instance on host. Failed to retrieve the configuration parameters of the [BAS-AS] service. Win32 error:The system cannot find the file specified. Code: 2
bucoops
Enthusiast
 
Posts: 38
Liked: 1 time
Joined: Mon Aug 01, 2016 6:37 pm
Full Name: Richard

Re: SQL truncate - removed instance now gives warning

Veeam Logoby Dima P. » Tue Aug 01, 2017 10:42 am

Richard,

Unfortunately, I am out of ideas. Please reach our support team and share the case Id in this thread. I can pass it you our QA team for further investigation. Thanks.
Dima P.
Veeam Software
 
Posts: 6387
Liked: 449 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL truncate - removed instance now gives warning

Veeam Logoby bucoops » Thu Aug 03, 2017 4:26 pm

Hi Dima,

I had to open a ticket by phone - the support portal would accept the support ID but I can't link it to my login to be able to start a ticket. Foolishly I forgot to ask for the ticket number...
bucoops
Enthusiast
 
Posts: 38
Liked: 1 time
Joined: Mon Aug 01, 2016 6:37 pm
Full Name: Richard

Re: SQL truncate - removed instance now gives warning

Veeam Logoby Dima P. » Thu Aug 03, 2017 9:38 pm

Richard,

You should receive the response with ticket id via email. Once you have it, please do not forget to share with us. Thanks!
Dima P.
Veeam Software
 
Posts: 6387
Liked: 449 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL truncate - removed instance now gives warning

Veeam Logoby bucoops » Fri Aug 04, 2017 8:04 am

Not had anything :(
bucoops
Enthusiast
 
Posts: 38
Liked: 1 time
Joined: Mon Aug 01, 2016 6:37 pm
Full Name: Richard

Re: SQL truncate - removed instance now gives warning

Veeam Logoby bucoops » Fri Aug 04, 2017 10:50 am

I've had to start a new one (02270706) as they couldn't find yesterdays - he's connected up now.

edit: it's actually looking like the SQL instance may not have uninstalled fully.
bucoops
Enthusiast
 
Posts: 38
Liked: 1 time
Joined: Mon Aug 01, 2016 6:37 pm
Full Name: Richard

Re: SQL truncate - removed instance now gives warning

Veeam Logoby Dima P. » Fri Aug 04, 2017 6:49 pm

Richard,

Thanks for the heads up. I'll pass your case ID to our QA team and DEVs (just in case). Let us know how it goes!
Dima P.
Veeam Software
 
Posts: 6387
Liked: 449 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL truncate - removed instance now gives warning

Veeam Logoby bucoops » Fri Aug 04, 2017 7:44 pm

Thanks - it's a bit strange as the service for the SQL shows up as failed (managed to miss that) but it doesn't show up in the SQL management kit. No errors when it was uninstalled.
bucoops
Enthusiast
 
Posts: 38
Liked: 1 time
Joined: Mon Aug 01, 2016 6:37 pm
Full Name: Richard

Re: SQL truncate - removed instance now gives warning

Veeam Logoby bucoops » Mon Aug 07, 2017 12:06 pm 1 person likes this post

A reboot after whatever the engineer did seems to have cleared it - I tried keeping up with what he was doing but too fast for my eyes!
bucoops
Enthusiast
 
Posts: 38
Liked: 1 time
Joined: Mon Aug 01, 2016 6:37 pm
Full Name: Richard

Re: SQL truncate - removed instance now gives warning

Veeam Logoby Dima P. » Tue Aug 08, 2017 7:35 pm

Glad you nailed it and thanks for updating this thread!
Dima P.
Veeam Software
 
Posts: 6387
Liked: 449 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov


Return to Veeam Agent for Windows



Who is online

Users browsing this forum: dheijl and 16 guests