Posts
Sort by recent activity
error messages
Monitoring a single server. Repository on monitored server. No issues for a couple of weeks, suddenly getting the following errors suggesting the monitor cannot connect to the monitored server. ...
highlight Begin / End
Please let me know if this capability exists already, but it would be great if SQL Prompt could highlight begin/end pairs similar to how it's done in SQL Assistant. I suppose if SSMS included a fe...
restore not recognizing default data and log directories
It would be very helpful if restore operations through the gui used the default database data and log file directories defined for a sql server instance. this is an easy registry setting to find. ...
File is locked
Attempting to restore a tlog backup file on the destination server in a log shipping scenario. Getting a File Locked error. I have tried performing the restore remotely (backup is located on the ...
instance list
How does one manage the SQL Server instance list? I want to delete/drop a SQL Server instance ( 2 actually) that no longer exists. I can add an instance, how do I drop one?
CONTINUE_AFTER_ERROR | STOP_ON_ERROR
This option is not explained in the documentation. It's listed, but there's no discussion. What is the effect of using either of these options?
documentation
Any chance that you will produce a printable (PDF) version of the documentation?
statement terminator invokes sql prompt
Whenever I type a semi-colon as a statement terminator, SQL Prompt displays a candidate list. I don't understand the purpose of that behavior, nor do I see anywhere in the options to turn that beh...
permanent connections?
Does SQL Backup always maintain active connections to the server, even when it is not performing any activity? I've noticed an open, idle connection for each thread specified in the backup command...
Log Shipping Restore job does not end
I have run into an issue with SQL Backup 5.3xx log shipping restore jobs.
The following code runs successfully in a SQL Agent job, however the job stays in an “Executing†state, which means it o...