Comments
Sort by recent activity
Hi Jessica It is a reporrt of where DBCC failed In the interim, I have created an SSRS report with the dataset as below (which I think is right) but the issue is that the tables do not update unless I go into the GUI, run a multiserver report for backups first
select server_name ,restore_start ,restore_end ,dbname ,convert(varchar, (restore_end - restore_start ), 108) as totaltime from SQLBackupReportingDatabase.dbo.restorehistory rh Join SQLBackupReportingDatabase.dbo.identities i on server_id = i.id where code = 821 and restore_type = 'D'
/ comments
Hi JessicaIt is a reporrt of where DBCC failedIn the interim, I have created an SSRS report with the dataset as below (which I think is right) but the issue is that the tables do not update unless ...