BE2010: Best Practice for a virtual MS SQL 2005 Server
I have a Windows Server 2008 R2 x64 running SQL Server 2005 on a Virtual Machine. The databases on that server are using the Full Recovery Model, which means that I need to perform Full DB Backups as well as Log Backups and truncate the Logs at some point.
I've tried the VMware Application GRT for SQL Servers which works smoothly for Full Backups. However, the Log files don't get truncated after the Backups, since no Log Backup Job has been run.
My question is: How do you backup your full recovery model DBs on a virtual MS SQL Server? Do you use the Windows Agent and treat the server like a physical machine? Or do you have a cronjob running on the SQL Server itsself to perform a Log-Backup? Or is there even a possibility to do a Log Backup Job via the VMware Agent? (I couldn't find any...)
Before the VMware Agent, I ran full backups at nights and a Log Backup during lunch break...
Thanks for your inputs,