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 ...

SQL Server Log Shipping in SQL Server has been around for a while and still provides an easy method for redundancy and load balancing.

Instead, it uses the technology that Lumigent developed for Log Explorer to monitor the SQL Server log files, so it knows about every logged operation in the database.

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 ...