Comments
Sort by recent activity
Thanks for the response Eddie. I am still trouble shooting this issue but I think the problem is more involved. This server has a default SQL2008R2 Developer instance which has had SQL Backup Pro installed and running for a couple of years. I recently (2 weeks) installed an instance of SQL2017 Developer and moved the dev databases to that instance (Detach/Attach) in SQL2008 compatibility. I used the same service account when I set up SQL Backup Pro on the new instance. I can still edit Backup Pro Server Options for the default instance but I cannot edit the options on the new instance. Notably, some of the server option settings I made during installation did take effect and some did not. I have found this error in the System Event Log. It occurs each time I try to update the Server Options on the SQL2017 Instance. Component: Software Version Agent Error: Could not read from the registry sub-key. Cause: This error can be caused by a corrupt registry or a low memory condition. Rebooting the server may correct this error. I am still checking the registry permissions and will update the thread when I complete that. I am considering "uninstalling" and reinstalling the server components on the SQL2017 instance. Do you think that would help or hurt? <Update 2019-08-30 13:00 CDT> I explicitly added the domain service account to the three registry keys for the named instance with Full Control. I restarted the service and refreshed the connection in the GUI. I still cannot modify "Server Options" through the GUI. BTW, The default instance Still works fine, even though the Service Account is not explicitly granted permissions on the registry keys. / comments
Thanks for the response Eddie. I am still trouble shooting this issue but I think the problem is more involved.This server has a default SQL2008R2 Developer instance which has had SQL Backup Pro i...
Hi Eddie, I finally gave up in frustration and just added the service account to the server local administrator's group and the various SQL Backup functions work fine now. I can update the Server Options using the GUI I previously verified correct permissions (Full Access) for the Registry Keys, the backup folders, Red Gate Data Folder and Red Gate Log Folder. Also, I was using essentially the same backup command you recommended. I generated SQL Agent backup jobs using the Red Gate GUI. The backups were throwing errors until I added the service account to local administrators. / comments
Hi Eddie,I finally gave up in frustration and just added the service account to the server local administrator's group and the various SQL Backup functions work fine now. I can update the Server O...
I will be out for a couple of weeks but I am still working on understanding this metric. I am sure there must be a way to make the numbers more meaningful. When you hover over the Wait chip it shows Signal Wait vs Resource Wait which is definitely an immediately meaningful number. I think High Signal to Resource clearly indicates a CPU issue. Perhaps Brent Ozar's Waits/Sec/Core would be more useful as the summary value shown on the Chip / comments
I will be out for a couple of weeks but I am still working on understanding this metric. I am sure there must be a way to make the numbers more meaningful. When you hover over the Wait chip it sh...
Hi Russell, I appreciate the reply and the information. However, the reply doesn't really answer my question. I understand that the value is intended to be an indicator but I don't understand how to interpret the values. If I tell you the temperature is 25 and you should dress accordingly then what are you going to wear? I have a feel for what the raw Wait time statistics mean and some idea of how to monitor and respond. Of course I want the numerator to be "small" but when does it stop being "small". I just don't have a feel for this s/s measure. What is a threshold? How do I determine when it indicates a problem? / comments
Hi Russell,I appreciate the reply and the information. However, the reply doesn't really answer my question. I understand that the value is intended to be an indicator but I don't understand how ...
Does this really need to be pinned to the top of the forum after almost 2 years? / comments
Does this really need to be pinned to the top of the forum after almost 2 years?
Where should I send it?
I re-enabled the Beta on my Dev servers. I have some screen shots from Nov 28 plus SQL Error Log. / comments
Where should I send it?
I re-enabled the Beta on my Dev servers. I have some screen shots from Nov 28 plus SQL Error Log.
Thanks Eddie. First, the issue seems to have resolved itself by magic.
The backup process did complete, the backup was produced and the backup file had the proper name in the proper primary location. The Log indicated that the backup completed and that the file had been copied to the network share.
However the secondary copy was not in place on the network share. I checked permissions, event logs, Red Gate logs, fiddled with settings etc. Magically, the file appeared the next morning.
Phase of the Moon I guess [image] / comments
Thanks Eddie. First, the issue seems to have resolved itself by magic.
The backup process did complete, the backup was produced and the backup file had the proper name in the proper primary locati...
I have the same issue with 9.1.4.177.
I ran the posted query which returned "<SQBUTILITYRESULT>:1:" .
The SQL Agent backup job completes successfully. It also runs successfully from an SSMS Connection.
However, the file is not copied to the network share. / comments
I have the same issue with 9.1.4.177.
I ran the posted query which returned "<SQBUTILITYRESULT>:1:" .
The SQL Agent backup job completes successfully. It also runs successfully from an SSMS Connec...
I go a step farther. I would like access to more of the standard job parameters from the wizard. For example, I like to have all jobs write to log files. We need some failed jobs to notify a SQL Agent Operator immediately (e.g. page or netsend).
I would also like an easy way to manage the unwieldy job names. It would be nice to have a set up option for the Job name similar to the Backup file name. [image] . / comments
I go a step farther. I would like access to more of the standard job parameters from the wizard. For example, I like to have all jobs write to log files. We need some failed jobs to notify a SQL...