MSSQL Simple Mode Settings

VMware specific discussions

MSSQL Simple Mode Settings

Veeam Logoby mcsmithSOP » Mon 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
mcsmithSOP
Enthusiast
 
Posts: 42
Liked: 2 times
Joined: Sun May 31, 2015 3:26 pm
Location: Regina, SK, CAD
Full Name: Jason

Re: MSSQL Simple Mode Settings

Veeam Logoby Gostev » Mon Dec 07, 2015 5:16 pm

Your settings are correct.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: MSSQL Simple Mode Settings

Veeam Logoby mcsmithSOP » Mon Dec 07, 2015 6:32 pm

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


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 16 guests