fiNal
15 years agoLevel 4
BE2010: Best Practice for a virtual MS SQL 2005 Server
Hi
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 Bac...
- 15 years agoOK, with AVVI agent, you will not be able to run log backup. Also, in order to run a log backup outside AVVI agent, you will need to perform a full backup using sql agent. AVVI backup is not recognized as a sql agent backup by SQL Agent. Hence, the limitation. So, the only solution, is to perform a full backup of sql database using sql agent, followed by log backup. If you do an AVVI backup, you might have to perform a full backup using SQL Agent again, so that log backup succeeds. Currently, this is the default behaviour of AVVI Agent in Backup Exec 2010.
Please mark it a solution, if this is useful.
Thanks