We just upgraded to v8. I see there is new application aware settings for SQL. I have tried reading through the documentation but cannot figure out what is the proper settings.
We have SQL servers that have a mix of SIMPLE and FULL recovery model databases on them. What is the proper settings when you have a SQL server that has databases that are mixed? I see that it has automatically changed my jobs to PERFORM COPY ONLY. Will this still back up a simple recovery database as well as CHECKPOINT the log file so that it will reuse space on a SIMPLE database?
Previously for SQL servers that have both full and simple recovery model databases I would run a full SQL backup job nightly and log file backups during the day. I would enable application aware processing and set it to not truncate logs. This would checkpoint the log files during the backup for SIMPLE databases so they can be reused but not truncating them.
Also what is the proper setting for a SQL server that has ONLY simple recovery databases. Process Logs and Do not truncate logs?
-
- Expert
- Posts: 162
- Liked: 15 times
- Joined: Nov 15, 2011 8:47 pm
- Full Name: David Borden
- Contact:
-
- VP, Product Management
- Posts: 27377
- Liked: 2800 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Help me with SQL application processing settings in v8
Databases with simple recovery mode are automatically skipped by SQL backup jobs, since there are no logs to ship to the backup repository. Please look through this page of the User Guide for additional details. Let me know if that helps!
-
- Enthusiast
- Posts: 31
- Liked: never
- Joined: Mar 19, 2015 9:23 am
- Full Name: Peter Schwartz
- Contact:
[MERGED] MS SQL2012
We have one MS SQL Sever 2012 with 3 databases. Two databases have the recovery model "simple" one database "full".
What kind of Application-Aware Process Options for the SQL Server should I use? "Truncate logs (prevent logs from growing forver)" oder "Do not truncate logs (requires simple recovery model)"
What kind of Application-Aware Process Options for the SQL Server should I use? "Truncate logs (prevent logs from growing forver)" oder "Do not truncate logs (requires simple recovery model)"
-
- Veteran
- Posts: 7328
- Liked: 781 times
- Joined: May 21, 2014 11:03 am
- Full Name: Nikita Shestakov
- Location: Prague
- Contact:
Re: Help me with SQL application processing settings in v8
Hello Peter,
As explained above, Databases with "Simple" recovery model are automatically skipped by SQL backup jobs, I would use truncate option for the Full model database.
Thanks!
As explained above, Databases with "Simple" recovery model are automatically skipped by SQL backup jobs, I would use truncate option for the Full model database.
Thanks!
-
- Veeam Software
- Posts: 21139
- Liked: 2141 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: Help me with SQL application processing settings in v8
Peter, what is the reason of having the Full recovery model for that database?
Who is online
Users browsing this forum: No registered users and 220 guests