I use to backup my Windows 2008 R2 SQL Server 2008 with Windows 2008 Backup on a USB external drive
Backup is done daily, and ends successfully without any error message
During backup SQL Server Service is NOT stopped and VSS is used by Windows Backup to backup SQL Server online
However I have been told that I should turn off SQL Server before backup (NET STOP MSSQLSERVER) and start it after Backup is finished (NET START MSSQLSERVER)
Is it necessary to turn off and on MSSQLSERVER service before and after running Windows 2008 Backup? or does VSS works fine and SQL Server can remain online?
I hope I have been clear with my English...
Thank you for your answer