# Backing Up Server 2012 R@ Access Denied **URL:** \ **Category:** Support\ **Created:** [September 7, 2018, 1:53am UTC](https://forum.duplicati.com/t/backing-up-server-2012-r-access-denied/4569 "2018-09-07T01:53:30Z")\ **Posts on this page:** 1\ **Showing post:** 10
**Author:** ![ts678](https://forum.duplicati.com/letter_avatar_proxy/v4/letter/t/8491ac/32.png) [@ts678](https://forum.duplicati.com/u/ts678)\ **Post date:** [September 11, 2018, 2:56am UTC](https://forum.duplicati.com/t/backing-up-server-2012-r-access-denied/4569/10 "2018-09-11T02:56:04Z")
We need to clear up the SQL Server versus MySQL confusion. They’re completely different databases. SQL Server seems to have good VSS support. [http://projectinabox.org.uk](http://projectinabox.org.uk) talks about SQL Server but not MySQL. CrashPlan is a file-oriented product that can use VSS (Duplicati is also), and such a plan has inherent limits: [Back up open files and databases](https://support.code42.com/CrashPlan/6/Backup/Back_up_open_files_and_databases) [Understand and troubleshoot backing up open files with Windows VSS](https://support.code42.com/CrashPlan/6/Troubleshooting/Understand_and_troubleshoot_backing_up_open_files_with_Windows_VSS) The above has links to explanations. Here’s another: [Crash-Consistent vs. Application-Consistent Backup](https://www.nakivo.com/blog/crash-consistent-vs-application-consistent-backup/) [SQL Writer Service](https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-writer-service?view=sql-server-2017) desribes the component of SQL Server that lets it better support backups that use VSS. [MSSQL backup how’s it work exactly?](https://forum.duplicati.com/t/mssql-backup-hows-it-work-exactly/1852) is some Duplicati-specific discussion, with a specific SQL Server plan. This discussion says how Duplicati asks the database engine to create an application-consistent snapshot, however it’s probably basically the same thing that any backup using VSS would do. See the above articles. Basically, it looks like getting the application-consistent backup needs VSS, and also some application help. [MS SQL does not backup modified files](https://forum.duplicati.com/t/ms-sql-does-not-backup-modified-files/427) is likely why --disable-filetime-check is used in detailed steps above. Successfully piecing together a system (or even an application) from a collection of files seems challenging. Don’t you want to carefully reinstall pieces out of the file backup, or does it really work to just install all of it? I have little personal experience with live image or high-cost backups, but some image backups do use VSS, possibly giving a backup that’s not quite as “best practice” as database dumps, but offers other advantages. [Backup Internals: What is VSS, how does it work and why do we use it?](https://blog.macrium.com/backup-internals-what-is-vss-how-does-it-work-and-why-do-we-use-it-4e566223125a) --- _[View the full topic](https://forum.duplicati.com/t/backing-up-server-2012-r-access-denied/4569)._