Backup SQL database
Hi guys!
The most importand data in our customers is their SQL databases. Now we are using SQL's backup with plans and taking in the local disk .bak files from SQL database.
One reason that we choose to use Acronis Cloud was that have SQL backup application.
I tested also in cloud and also in local network via NAS to take back-up and i noticed that it is taking the .mdf & .ldf files.
The problem is that when SQL service is running if it took the mdf & .ldf files is useless because they are in use from SQL service, so when i'm trying to attach the files in SQL is int possible, and i got error.
Also i tried via Application backup from whole machine and i noticed that did the same, its coppied mdf & .ldf files!
Is there any whey to take SQL back-up? One way i'm thinking is with post coammnd one command to take down the SQL service before back-up and one command after back-up to run the SQL service.
Is there any other way?
Thanks in advanced.

- Se connecter pour poster des commentaires

Hello Stilianos,
Stopping the databases before backup and resuming after is one of the possible ways to secure the consistent copy of sql, but it's mostly recommended as a workaround in case you have issues with the Volume Shadow Copy service (VSS) or applications that are not compatible with VSS.
In all other cases the files are backed up with the help of the VSS Writers that allow creating consistent copies of running MS applications such as SQL, Exchange or AD. You can either use Application backup option in the plan, or create a separate plan for SQL databases only, see Protecting applications.
- Se connecter pour poster des commentaires

Yes Ekaterina i noticed that its ok with VSS. The only problem now is SQL 2008r2. Im backing up 2008r2 database with acronis and when im going to restore it to 2008r2 back again says
"The database cannot be opened because it is version 706 (this with back up format 11 and with 12 says 782). This server supports version 661 and earlier. A downgrade path is not supported."
Some of our customers have SQL 2008R2 and we are sad about that.
Is there any solution about 2008r2 databases?
- Se connecter pour poster des commentaires

Hello Stilianos,
according to the third-party forums, this error message means the database file in the backup and the target databases actually have different versions, e.g. the older server can't support the newer database format.
https://forums.asp.net/t/1934100.aspx?Getting+error+cannot+be+opened+because+it+is+version+706
https://www.sqlservercentral.com/Forums/Topic1621506-391-1.aspx
As far as I understand, 706 corresponds to SQL Server 2012 and 661 to SQL Server 2008R2
- Se connecter pour poster des commentaires

Yes thats right, but my problem is that im backing up 2008r2 database with acronis and when i want to restore it to 2008r2 again says this message. Its like Acronis transformate my database to newer version! So icant use acronis cloud backup to our clients because many of them have 2008r2!
Is there any solution about that?
- Se connecter pour poster des commentaires

Hello Stilianos,
I'm not aware of any cases, where the version of the databases in the backup has been changed or recognized as a different one. I'd recommend raising a support ticket for this issue, if you're sure the SQL server version actually matches one in the backup. Please let us know the results of the investigation.
- Se connecter pour poster des commentaires

Ekaterina was my fault i thought that the database is 2008 but was 2012. Everything ok!
- Se connecter pour poster des commentaires

Stilianos wrote:Ekaterina was my fault i thought that the database is 2008 but was 2012. Everything ok!
Good to know, thank you for an update / feedback!
- Se connecter pour poster des commentaires