Comments
Sort by recent activity
Daniel,
Having spent more time in the application I think these are being grouped together because the Detail column is blank/empty. Maybe just getting the Process Name or something into the Detail if the Detail is otherwise empty would sort it ...?
cheers
Jonathan / comments
Daniel,
Having spent more time in the application I think these are being grouped together because the Detail column is blank/empty. Maybe just getting the Process Name or something into the Detail...
Just stopping the process gets the application working again.
I have removed the files as you mention.
The error message and the application starts up cleanly each time now - tested 3 times.
for Vista users, the file location above is ...
%:\Users\<username>\AppData\Local\Red Gate\SQL Backup\Server Data / comments
Just stopping the process gets the application working again.
I have removed the files as you mention.
The error message and the application starts up cleanly each time now - tested 3 times.
for Vi...
Hi,
Wouldnt it be best if the report that is generated is made available to a SQL Report Server so it can be scheduled from that and then emailed/accessed as necessary? There could be a suite of reports for Red Gate products...
In the reporting GUI would it be possible to have a 'save settings' option? every day i run the reports i have to re-enter all the same details - multiple servers/choose server/choose database/choose servers ...
cheers / comments
Hi,
Wouldnt it be best if the report that is generated is made available to a SQL Report Server so it can be scheduled from that and then emailed/accessed as necessary? There could be a suite of re...
I would agree that diagrams are much quicker for refreshing yourself with a schema and understand what connections there are beyond the 'first hop'. / comments
I would agree that diagrams are much quicker for refreshing yourself with a schema and understand what connections there are beyond the 'first hop'.
I have a similar issue.
In my table I have colA and colB, colA MUST be 1 if ColB has any value in it, otherwise colA should be 0. I cannot seem to get Data Generator to insert any rows, it just returns an error saying the INSERT conflivted with a check constraint.
In the UI I have colA set to bit, no nulls and colB to description allow nulls. I have the "when data is invalid" option set to "skip row".
Why do no rows get inserted? surely some rows must be generated that are colA=1, colB='Some text'?? / comments
I have a similar issue.
In my table I have colA and colB, colA MUST be 1 if ColB has any value in it, otherwise colA should be 0. I cannot seem to get Data Generator to insert any rows, it just ret...
Hi,
I have (since 01/01/09) had several SQL Backup jobs fail with
"SQL Backup failed with exit code: 586 SQL error code: 0 [SQLSTATE 42000] (Error 50000)"
but I am running 64bit SQL 2005 SP2 on server 2003 R2.
Will the same fix be relevant or is this another issue altogether?
cheers
Jonathan / comments
Hi,
I have (since 01/01/09) had several SQL Backup jobs fail with
"SQL Backup failed with exit code: 586 SQL error code: 0 [SQLSTATE 42000] (Error 50000)"
but I am running 64bit SQL 2005 SP2 on se...
Problem Solved:
have to leave work soon so only a short explanation...
when you run reports for multiple servers you as a domain account are requesting data from SQL Servers (behind the scenes there are extended sp's that go via dll's to interrogate log files) and as such your network credentials are used.
the 'double hop' mentioned in the comment/article above applies but the linked server security needs to be applied to the account of the person requesting the report...
on serverB (or indeed C etc ...) create a local SQL logon for SQL Backup to use, ensure that this logon is a datareader user in the master datbase and specifically execute permission on the master.dbo.sqbdata extended stored procedure use master
GO
GRANT EXECUTE ON dbo.sqbdata TO SQLBackupService
GO
on serverA add a linked server and for the domain account or group that relates to the users who will be running reports from SQLBackup, create a mapping for them to login to ServerB as the SQL login created above.
hope this is accurate and helps out some people.
RedGate - please alter / amend as necessary to better explain how SQL Backup is gathering the data.
Jonathan / comments
Problem Solved:
have to leave work soon so only a short explanation...
when you run reports for multiple servers you as a domain account are requesting data from SQL Servers (behind the scenes ther...
Thanks Matthew, i have the templates moved over.
Maybe this process is a potential development for the next version? Using the SQL Backup GUI would have been a lot easier as i can see all my servers from there...
cheers
Jonathan / comments
Thanks Matthew, i have the templates moved over.
Maybe this process is a potential development for the next version? Using the SQL Backup GUI would have been a lot easier as i can see all my server...
Hi,
didnt realise there was a difference in getting code to layout in Refactor or Prompt. I was using B + L as described, just under the impression that Prompt was doing the work. Thanks for putting me on the right track.
I have (this afternoon) stopped the system tray icon (RGHT Click + choose exit) and now both CTRL-B + CTRL-L and CTRL-K + CTRL-Y work as normal. no more system crashes for the last 15 minutes...
Jonathan / comments
Hi,
didnt realise there was a difference in getting code to layout in Refactor or Prompt. I was using B + L as described, just under the impression that Prompt was doing the work. Thanks for puttin...