Discussions specific to the VMware vSphere hypervisor
Post Reply
mcsmithSOP
Enthusiast
Posts: 42
Liked: 2 times
Joined: May 31, 2015 3:26 pm
Full Name: Jason
Location: Regina, SK, CAD
Contact:

MSSQL Simple Mode Settings

Post by mcsmithSOP » Dec 07, 2015 5:12 pm

What are the correct settings when the MSSQL database is set to Simple Mode recovery?

I've read this: http://helpcenter.veeam.com/backup/80/v ... 2Brecovery but what's throwing me off is:
So, with this option selected, your database administrator will have to take care of database logs
The Microsoft documentation for SQL Recovery Models states that "Automatically reclaims log space to keep space requirements small, essentially eliminating the need to manage the transaction log space."

So which is it?

I have a particular backup job that has a mix of non-SQL and SQL servers. My settings under Advanced Settings > vSphere are "Enable VMware Tools quiescence" for the non-application aware VM, and under Guest Processing "Enable application-aware processing" is selected, General Tab > "Process transaction logs with this job" is selected and SQL Tab > "Do not truncate logs" is selected

Gostev
SVP, Product Management
Posts: 24797
Liked: 3553 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: MSSQL Simple Mode Settings

Post by Gostev » Dec 07, 2015 5:16 pm

Your settings are correct.

mcsmithSOP
Enthusiast
Posts: 42
Liked: 2 times
Joined: May 31, 2015 3:26 pm
Full Name: Jason
Location: Regina, SK, CAD
Contact:

Re: MSSQL Simple Mode Settings

Post by mcsmithSOP » Dec 07, 2015 6:32 pm

Thank you.

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google [Bot], oliverL and 30 guests