Posts
Sort by recent activity
Is there a tool to automate running a process on every database every day
We have tried to set up a job that uses sp_MSForeachDB to run the same stored procedure on every database in our system but we run into issues with permissions or SQL statement being truncated. Wh...
Can I reduce or remove the file RedgateMonitor.bak?
We are running low on disk space and I noticed that there is a file RedgateMonitor.bak that is over 12GB in size. Is it OK to remove this file or is there a way to shrink it down?
Adding to SSMS v 18
I had SQL Prompt 9 installed on SSMS 15 but when I installed SSMS v 18 it is not available. I tried uninstalling it and re-installing it but it is still not available.
Exit Code 505
Over the weekend our SQL Backup jobs locked up on something and I had a huge mess to clean up on Monday. I am not sure if it was the job that backs up all of the databases once a day or the one th...
Log Shipping
Our log shipping was running for almost 2 weeks when it started failing to restore the log files over and over again. I am not sure why it was failing but I am trying to create a new log shipping ...
Earlier Log files keep getting skipped
We have been using SQL Backup for log shipping for 4 months now. Every week we reach a point where the restore job starts failing. I am able to track the error an invariably it always turns out t...
SQL Backup process keeps trying to copy a file and I can't stop it
We are using SQL Backup for Log Shipping. This morning it started sending messages that it was getting an error copying a file. One of the Transaction Log files it was trying to copy to the share...
Log Shipping Timeout
We have set up log shipping using SQLBackup 9.2 and about 5 or 6 times a day we get an error message that it failed due to timeout. When it runs again 15 minutes later it usually works but there a...