Direkt zum Inhalt

Sql express backup

Thread needs solution

Hi, is it possible to backup an sql express database using Acronis true image 2020? And eventually using Acronis true image 2019?????

0 Users found this helpful

Claudio, welcome to these public User Forums.

It is not normally recommended to backup any active SQL database outside of the SQL application itself as such files are normally locked by the application and not be accessible by Acronis.

Assuming that when referring to SQL Express you are meaning the Microsoft SQL Server Express application, then see webpage: How to schedule and automate backups of SQL Server databases in SQL Server Express

Once you have created a backup of the database(s) using the application features, then those backup files can be backed up by Acronis True Image.

I agree with Steve, that's the best way to go.

Technically, True Image can backup SQL database "as is" at the point in time the backup is run, but would not capture any ongoing changes... it takes a snapshot in time using VSS, which is supposed to be able to capture a live database.   However, in practice, and if you want the best reliability of that backup and the data in the database, I also think that taking the backup directly in MySQL is the way to go and then backing those up with True Image for history/retention/recovery of those database backups would be the most reliable.

Plus, going that route, if backing up the entire system, you'd have multiple options to try and restore from... the current database and point in time as captured in the full system backup as well as the more specific SQL backup files.