Standalone backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)
Post Reply
Klausgodtkjaer
Novice
Posts: 4
Liked: never
Joined: Mar 27, 2018 10:25 am
Full Name: Klaus G
Contact:

Win10 and SQL backup?

Post by Klausgodtkjaer » Feb 13, 2019 10:52 am

Hi.

So I've got a Win10 pro 64bit desktop, with a newly Installed Microsoft SQL Server Express.

Will a free Veeam Agent, doing a "Entire PC" be able to correctly backup the SQL-Database?

Is there anything I should be aware of in this case? I need the "Entire PC" do to other reasons, så if this could include the just installed SQL Express, that would be great.

HannesK
Veeam Software
Posts: 2768
Liked: 343 times
Joined: Sep 01, 2014 11:46 am
Location: Austria
Contact:

Re: Win10 and SQL backup?

Post by HannesK » Feb 13, 2019 11:39 am

Hello,
it will be application consistent as the agent always runs VSS. But the free version is not able to do log-shipping (probably not required in your environment).

Does that help?

Best regards,
Hannes

Klausgodtkjaer
Novice
Posts: 4
Liked: never
Joined: Mar 27, 2018 10:25 am
Full Name: Klaus G
Contact:

Re: Win10 and SQL backup?

Post by Klausgodtkjaer » Feb 18, 2019 9:36 am

Thank you for your input.

What I am worring about, is what happens if the SQL is backed up, at the same time the database is used? I should mention I am not that familliar with using SQL-databases.

If there is no good answer, I will use a third party app to export the SQL-database to c:\SQL-Backup\ and then that would be included in the backup. Not pretty, but it works :)

HannesK
Veeam Software
Posts: 2768
Liked: 343 times
Joined: Sep 01, 2014 11:46 am
Location: Austria
Contact:

Re: Win10 and SQL backup?

Post by HannesK » Feb 18, 2019 9:52 am

is what happens if the SQL is backed up, at the same time the database is used
Microsoft VSS handles that. No worries.

as long as you do image based backup (full computer / volume level), you will always have the database in your backup.

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests