Help! My SQL Server Log File is too big!!! Your email has been sent Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim ...
Welcome to this new series -- in this column, I hope to impart some quick, short tips that will help you make quick work of managing and administering your SQL Server databases. First up is an ...
Log backups must be applied in the sequence in which they were created, without any gaps in the log chain. For more information about transaction log backups, see Transaction Log Backups (SQL Server) ...
Last time, we discussed the different backup types available in SQL Server. Now, let's take a quick look at some best practices when it comes to configuring those backups. Although there is no one set ...
What is the current behavior? When used with OH based full/diff backups that use the @NumberofFiles parameter for multiple backup files, the file number is appended to the end of the file name. When ...
Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback