-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: June 2018

The transaction log for database ‘MyDB’ is full due to ‘LOG_BACKUP’

Your transaction log is full. Both Microsoft, and about 100 articles and blogs have covered this topic, but let's take a quick look anyway. Because, you know, it comes up all the time.

The post The transaction log for database ‘MyDB’ is full due to ‘LOG_BACKUP’ appeared first on The… Read more

1 comments, 114 reads

Posted in SQL Awesomesauce on 14 June 2018

Generate RESTORE LOG statements

Today, we're going to take a specific, simple example of generating RESTORE LOG statements from a directory list of files, using Powershell and find-and-replace.

The post Generate RESTORE LOG statements appeared first on The MidnightDBA Star-Times.

Read more

0 comments, 587 reads

Posted in SQL Awesomesauce on 6 June 2018