Activity overview
Latest activity by craighb
Advice for accessing the data directly
I want to access the data in the SQL Monitor database. Is there a recommended way to access the data?
yes, we load the datawarehouse regularly, but that should change the recovery model / comments
yes, we load the datawarehouse regularly, but that should change the recovery model
Last db backup: 27/12/2014 02:13:17 (for Datawarehouse4: we do a full backup every Sat morning. no diff backups. no log backups)
Last db log backup: None
I have added the screenshot to dropbox: https://www.dropbox.com/sh/4y5hrpd8se85 ... iyV0a?dl=0 / comments
Last db backup: 27/12/2014 02:13:17 (for Datawarehouse4: we do a full backup every Sat morning. no diff backups. no log backups)
Last db log backup: None
I have added the screenshot to dropbox:htt...
Hi Alex
Thanks for getting back to me.
SQL Server Version:
Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
May 14 2014 18:34:29
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
Screenshots and Logs https://www.dropbox.com/sh/4y5hrpd8se85 ... iyV0a?dl=0
You asked for "logs from SQL Monitor". I couldn''t find any way to export logs from SQL Monitor, so included a screenshot of the alert details
previous post about this: http://www.red-gate.com/messageboardold ... 37afdffe00
Hope that helps. If you need any more let me know.
Craig / comments
Hi Alex
Thanks for getting back to me.
SQL Server Version:
Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
May 14 2014 18:34:29
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Window...