Activity overview
Latest activity by SQL_Dude
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?
Resolved it myself finally. Turns out you have to uninstall SQL Prompt, then download a new Trial version. Install that and then add the product license again. / comments
Resolved it myself finally. Turns out you have to uninstall SQL Prompt, then download a new Trial version. Install that and then add the product license again.
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.
Changing to C didn't seem to work. I'm finally getting e-mail messages that the 24 hour time limit has expired but I will probably be getting these for the next couple of hours. / comments
Changing to C didn't seem to work. I'm finally getting e-mail messages that the 24 hour time limit has expired but I will probably be getting these for the next couple of hours.
Hey Dan, We updated to the latest version of SQL Backup. Running this on SQL Server 2012 on a clustered server. The problem above started happening again this week and I'm unable to get past it this time. Attaching one of the log files for review Thanks for your help. / comments
Hey Dan,We updated to the latest version of SQL Backup. Running this on SQL Server 2012 on a clustered server.The problem above started happening again this week and I'm unable to get past it this...
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...