By Lori Brown | Log Shipping , SQL Administration , SQL Server
Log Shipping has been around a long time and it looks like it will continue to be useful and therefor supported. Since I still find Log Shipping being used, let’s talk about a T-SQL way to monitor it.
Continue readingBy Lori Brown | Backup and Restore , Helpful Scripts , Log Shipping , SQL Administration , SQL Maintenance , SQL Server
I have a client that uses a lot of disconnected log shipping on a few servers. They do this because they want to have a copy of their database that is actually hosted by software vendors for reporting purposes. So, disconnected log shipping it is! We pull down files that have been FTP’d to the […]
Continue readingBy Ginger Daniel | Backup and Restore , Log Shipping , SQL Administration , SQL Server
For years the SQL Agent service account on my client’s SQL Server instance ran the Maintenance Plans and SQL Agent jobs with no issues. Many of the SQL databases were set to Full recovery model, and Tlog backups executed on regular bases with no problems. The client decided to migrate to new hardware in a […]
Continue readingBy Lori Brown | Expert , Log Shipping , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah I have a few clients who have set up SQL instances to hold copies of databases from either vendors or other companies with whom they are actively sharing data with. In these cases, since the source databases are on servers that are part of another company’s domain, the best way […]
Continue reading