Comments
Sort by recent activity
This has been resolved. The service account requires SYSADMIN privileges - which violates our security protocols.
/ comments
This has been resolved. The service account requires SYSADMIN privileges - which violates our security protocols.
Never mind - seems similar to https://forum.red-gate.com/discussion/88221/sql-prompt-intellisense-causes-sql-management-studio-failure#latest / comments
Never mind - seems similar to https://forum.red-gate.com/discussion/88221/sql-prompt-intellisense-causes-sql-management-studio-failure#latest
Same SQL Prompt and SSMS versions.
My issues are typing RAND() and CONVERT().
/ comments
Same SQL Prompt and SSMS versions.
My issues are typing RAND() and CONVERT().
Thank you David. / comments
Thank you David.
SQL Backup client was showing "Failed to open local data store: data.sdf" error. Did the rename per https://forum.red-gate.com/discussion/11653/recurring-402-failed-to-open-local-data-store-data-sdf
And now, error is gone; but, I cannot get the latest backup information on SQL Backup GUI for that server. / comments
SQL Backup client was showing "Failed to open local data store: data.sdf" error.Did the rename per https://forum.red-gate.com/discussion/11653/recurring-402-failed-to-open-local-data-store-data-sdf...
Granted Full Control to HKLM\SOFTWARE\Red Gate\SQL Backup\ to Service Account and that fixed it. Per solution here - https://forum.red-gate.com/discussion/19160/sql-backup-failed-with-exit-code-669
/ comments
Granted Full Control to HKLM\SOFTWARE\Red Gate\SQL Backup\ to Service Account and that fixed it.Per solution here - https://forum.red-gate.com/discussion/19160/sql-backup-failed-with-exit-code-669
Great suggestion. Initial test shows DB_BACKUPOPERATOR fixed the issue.
I would have thought it needed similar role to MSDB considering it's a job, but surprisingly, not.
Will update further if it fails when the job runs by itself. Thank you Petey2
/ comments
Great suggestion. Initial test shows DB_BACKUPOPERATOR fixed the issue.
I would have thought it needed similar role to MSDB considering it's a job, but surprisingly, not.
Will update further if i...
On the right panel of SQL Dependency Tracker, you should see Objects in Project tab. Highlight all the stored procedures (SP) by clicking on the first SP name, scroll down and clicking on the last SP name, then click on the checkbox to uncheck. Once all the SPs are unchecked, the diagram should automatically update to show Tables only. Hope that helps. / comments
On the right panel of SQL Dependency Tracker, you should see Objects in Project tab. Highlight all the stored procedures (SP) by clicking on the first SP name, scroll down and clicking on the last ...
I don't work for RedGate; but, I was looking for the same thing and found
https://documentation.red-gate.com/sbu9/release-notes-and-other-versions/sql-backup-pro-9-2-release-notes
Version 9.2.5 June 6th, 2018
This release of SQL Backup includes the following update:
Features
The configuration of reports can now be persisted.
/ comments
I don't work for RedGate; but, I was looking for the same thing and found
https://documentation.red-gate.com/sbu9/release-notes-and-other-versions/sql-backup-pro-9-2-release-notes
Version 9.2.5 Ju...
This is the URL that describes the fixes, etc https://support.microsoft.com/en-us/help/4057119/cumulative-update-7-for-sql-server-2016-sp1
If you are looking for issues with Red-Gate products, I am still running tests on a test server, but, so far, I don't have any issues. I cannot fully tests all RedGate products because like I said, this is test server, and I do not have real world databases (nor RedGate SQL Backup licences) in the instance.
Hope that helps. / comments
This is the URL that describes the fixes, etchttps://support.microsoft.com/en-us/help/4057119/cumulative-update-7-for-sql-server-2016-sp1
If you are looking for issues with Red-Gate products, I am ...