In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

We currently have a SQL 2008 server running as a VM. We backup nightly using Veeam and my consultant also advise we backup on top of that via BackupExec.

In SQL Server 2005 and later, you can create a transaction log backup while a full or differential backup is occurring, but the log backup will not truncate the log due to the fact that the entire ...