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

Archives: June 2018

Minion Backup: Restore to another server

Minion Backup makes your SQL Server backups effortless, of course.  And even better, it makes your restores effortless! Oh, yes….yes indeed. Today we’ll look at configuring a common, repeatable scenario: take the latest backup of MyDB from ProdServer1 and restore it to DevServer1. There are four basic steps to the… Read more

1 comments, 246 reads

Posted in SQL Awesomesauce on 28 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, 234 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, 698 reads

Posted in SQL Awesomesauce on 6 June 2018