Standalone backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)
Post Reply
BFost
Novice
Posts: 6
Liked: 1 time
Joined: Aug 21, 2020 1:24 pm
Contact:

Question about SQL Express 2012 end of life

Post by BFost »

Hi, I just installed Veeam Agent for Windows version 5, and noticed that SQL Express 2012 localdb was installed with it. I have been trying to get rid of SQL Express 2012 from my environment because of security scans looking for end of life software. I have heard that SQL Express 2012 goes end of life in July 2022. At this point will it be possible to upgrade it? Thanks.
Gostev
Chief Product Officer
Posts: 31455
Liked: 6646 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Question about SQL Express 2012 end of life

Post by Gostev » 3 people like this post

Hi, I'm not sure about upgrade possibility. But the next version of Veeam Agent for Windows will not use LocalDB at all. Thanks!
BFost
Novice
Posts: 6
Liked: 1 time
Joined: Aug 21, 2020 1:24 pm
Contact:

Re: Question about SQL Express 2012 end of life

Post by BFost »

Thanks, I appreciate it.
SigHunter
Lurker
Posts: 1
Liked: never
Joined: Mar 06, 2022 3:40 pm
Contact:

Re: Question about SQL Express 2012 end of life

Post by SigHunter »

Gostev wrote: Feb 18, 2022 11:48 pm Hi, I'm not sure about upgrade possibility. But the next version of Veeam Agent for Windows will not use LocalDB at all. Thanks!
can you please elaborate on that?
Gostev
Chief Product Officer
Posts: 31455
Liked: 6646 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Question about SQL Express 2012 end of life

Post by Gostev »

Not much to expand here really... it will be like all other Veeam Agents (for Linux/Mac/AIX/Solaris) which also do not use LocalDB.
BFost
Novice
Posts: 6
Liked: 1 time
Joined: Aug 21, 2020 1:24 pm
Contact:

Re: Question about SQL Express 2012 end of life

Post by BFost »

Hi, I wanted to check to see if there was any update on this. The most recent Veeam Agent for Windows Free on the website is 5.0.3, and it still requires Microsoft SQL Server 2012 SP4 Express LocalDB Edition. I believe this will not receive security patches after July 12, 2022. Is there any new info on this? Vulnerability management scanners don't like to see end of life software. Thanks!

https://docs.microsoft.com/en-us/lifecy ... of-support
Gostev
Chief Product Officer
Posts: 31455
Liked: 6646 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Question about SQL Express 2012 end of life

Post by Gostev » 1 person likes this post

Extended Security Updates will still be provided for SQL Server 2012 through July 8, 2025.

Alternatively, keep in mind you can always switch to using "managed by server" agent-based backup job type in Veeam Backup & Replication for protecting your physical machines. This job type doesn't deploy full blown agent with LocalDB.
BFost
Novice
Posts: 6
Liked: 1 time
Joined: Aug 21, 2020 1:24 pm
Contact:

Re: Question about SQL Express 2012 end of life

Post by BFost »

Thanks, I appreciate it.
JPMS
Expert
Posts: 103
Liked: 31 times
Joined: Nov 02, 2019 6:19 pm
Contact:

Re: Question about SQL Express 2012 end of life

Post by JPMS »

Gostev wrote: Feb 18, 2022 11:48 pm Hi, I'm not sure about upgrade possibility. But the next version of Veeam Agent for Windows will not use LocalDB at all. Thanks!
Do you know if this is likely to be released before SQL Express 2012 goes EOL.

We recommend Veeam Agent for Windows to friends and colleagues for their stand alone use (like home PCs). "Managed by server" and ESU are not an option.
Gostev
Chief Product Officer
Posts: 31455
Liked: 6646 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Question about SQL Express 2012 end of life

Post by Gostev »

No, definitely well after that.
JPMS
Expert
Posts: 103
Liked: 31 times
Joined: Nov 02, 2019 6:19 pm
Contact:

Re: Question about SQL Express 2012 end of life

Post by JPMS »

I appreciate it is offered as a free solution but I'm pretty disappointed in Veeam that they haven't addressed this prior to 2012 EOL. It's not like Microsoft don't publicise these dates far in advance. I appreciate that the non-database version may be a significant development but how hard would it have been to integrate a newer version of SQL Express?

Veeam surely understand the importance of using supported software. I feel I have given poor advice to others and it damages my, and their, confidence in Veeam products.
Gostev
Chief Product Officer
Posts: 31455
Liked: 6646 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Question about SQL Express 2012 end of life

Post by Gostev » 2 people like this post

It's not simple unfortunately and comes with very significant QC costs. So naturally we don't want to spend time on this, further delaying the new agent version that does not use SQL Express at all.

And no, actually we're not that worried about vendors officially supporting the 3rd party components we're using. In fact, the majority of the 3rd party components we use were NEVER officially supported by their author or vendor to start with, but rather provided "without support or warranties of any kind". Besides, some of those authors and vendors no longer exist even - and yet we're able to maintain the corresponding components and fix/patch them as needed. I guess the best example is those older/unsupported VMware VDDK versions that we carry to be able to process the corresponding older/unsupported ESXi versions... somehow no one ever saw an issue with us using them (despite being officially unsupported) in the past 10 years.

In the end, what matters is that Veeam will support customers using our product regardless of the support status of its individual components. The only difference is that from July, in case of non-security issues with LocalDB we will be on our own and will have to patch them ourselves. Although the chances that the most stable 10 years old LocalDB code will suddenly break after July are near zero anyway.
JPMS
Expert
Posts: 103
Liked: 31 times
Joined: Nov 02, 2019 6:19 pm
Contact:

Re: Question about SQL Express 2012 end of life

Post by JPMS »

"The only difference is that from July, in case of non-security issues with LocalDB..."

I should have made my concerns clearer, I agree, SQL 2012 is unlikely to suddenly break but what happens if there is a security issue which MS no longer patch because the product is not supported?
Gostev
Chief Product Officer
Posts: 31455
Liked: 6646 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Question about SQL Express 2012 end of life

Post by Gostev »

Security updates will still be provided by Microsoft, see my earlier post above.
JPMS
Expert
Posts: 103
Liked: 31 times
Joined: Nov 02, 2019 6:19 pm
Contact:

Re: Question about SQL Express 2012 end of life

Post by JPMS »

I did read your earlier post, "Extended Security Updates will still be provided for SQL Server 2012 through July 8, 2025." but those are only available as a purchasable option. Are you suggesting end users do that? Or are you saying that you subscribe to them and can include them in product updates?
Gostev
Chief Product Officer
Posts: 31455
Liked: 6646 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Question about SQL Express 2012 end of life

Post by Gostev » 2 people like this post

Actually, it was never possible to get SQL LocalDB updates for end users, whether security or regular, as it is excluded from Windows Update by Microsoft. It was always on us to include them into the next VAW build, so we would just continue doing so should they appear. Which is again quite unlikely after 10 years and considering that SQL LocalDB has no remote interfaces in principle (it can only be accessed locally).
mberrey
Veeam Software
Posts: 16
Liked: 1 time
Joined: Oct 10, 2022 4:03 pm
Full Name: Matthew Berrey
Contact:

Re: Question about SQL Express 2012 end of life

Post by mberrey »

Will v6 of Veeam Agent for Windows continue to use MS SQL Express or will it switch to SQLite?
HannesK
Product Manager
Posts: 14287
Liked: 2877 times
Joined: Sep 01, 2014 11:46 am
Full Name: Hannes Kasparick
Location: Austria
Contact:

Re: Question about SQL Express 2012 end of life

Post by HannesK » 1 person likes this post

Hello,
and welcome to the forums.

Yes, the next Veeam Agent for Windows (version 6.0) will use SQLite. No more SQL LocalDB.

Best regards,
Hannes
Dima P.
Product Manager
Posts: 14396
Liked: 1568 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Question about SQL Express 2012 end of life

Post by Dima P. »

Hello folks,

v6 goes live today and as promised SQL Express LocalDB is no longer used for the Veeam Agent for Windows configuration database. Please upgrade at your convenience and let us know how it goes! Happy upgrade!
swiffer
Novice
Posts: 4
Liked: never
Joined: Aug 03, 2020 7:15 pm
Contact:

Re: Question about SQL Express 2012 end of life

Post by swiffer »

Users upgrading from v5 need to manually uninstall SQL Server 2012 components, rights?
Dima P.
Product Manager
Posts: 14396
Liked: 1568 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Question about SQL Express 2012 end of life

Post by Dima P. »

Correct, unfortunately we cannot verify that localdb is not in use by other applications, so we cannot remove it automatically.
azpets
Enthusiast
Posts: 25
Liked: 7 times
Joined: Dec 05, 2020 4:08 pm
Full Name: A.Z. SRL
Contact:

Re: Question about SQL Express 2012 end of life

Post by azpets »

Strange.
Veeam client knows it's "db". So during update query the localdb if there are DBs... than understand if there's only the client DB or more...
Dima P.
Product Manager
Posts: 14396
Liked: 1568 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Question about SQL Express 2012 end of life

Post by Dima P. »

Good question, thank you! Sure, we could delete db but we cannot check other software's the dependency on MS SQL components. Additionally, leaving the configuration db and SQL components as-is allows us to harmlessly revert database migration during upgrade to v6. If anything goes wrong we stop the upgrade and leave you current setup up and running.
william.scholes
Service Provider
Posts: 10
Liked: 6 times
Joined: Nov 24, 2020 2:30 am
Full Name: William Scholes
Contact:

Re: Question about SQL Express 2012 end of life

Post by william.scholes » 3 people like this post

You can delete the Veeam Agent SQL LocalDB with this command;
#Start CMD with PSEXEC.exe to gain access to LocalDB running under LOCAL SYSTEM account
psexec.exe -i -s cmd.exe
#Check what instances exist
sqllocaldb i
#Delete the SQL LocalDB instance for Veeam Agent
sqllocaldb delete VeeamEndPoint
#now you can uninstall LocalDB from programs and features
mcbsys
Influencer
Posts: 19
Liked: 5 times
Joined: Sep 07, 2018 3:23 pm
Contact:

Re: Question about SQL Express 2012 end of life

Post by mcbsys »

Very helpful @william.scholes, thanks.

Another confirmation of which endpoints are installed for LocalDB is to look at folders here:

C:\Windows\System32\config\systemprofile\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances

I believe that LocalDB could theoretically put instances in other users' AppData folders, so the

Code: Select all

sqllocaldb i
approach seems more reliable for enumerating instances

Note that after removing the VeeamEndpoint instance and uninstalling LocalDB from Programs and Features, the folder will still exist with old error and trace logs, but the mdf files are gone.
Post Reply

Who is online

Users browsing this forum: No registered users and 42 guests