Viewing 15 posts - 2,566 through 2,580 (of 2,855 total)
If you were willing to spend some money, I'd do it with 4 separate VM's and then load up a tool like DxEnterprise (similar to Polyserve back in the day)....
April 24, 2017 at 8:43 am
April 20, 2017 at 2:46 pm
April 20, 2017 at 12:09 pm
Just because the "Events" table has information you don't care about, there was also 8 consistency errors in database 'ACSA'.
Running that could drop things you DO care about. It...
April 20, 2017 at 11:21 am
Pretty sure that means your DB is corrupt. I'd run DBCC CHECKDB
and see if it is bad. If so, I'd run it on your live one...
April 20, 2017 at 8:37 am
April 19, 2017 at 4:24 pm
If you are not using Enterprise Edition, you should check the ReportServer.dbo.Keys table. Actually, even if you are using enterprise edition, might not hurt to check that. Standard will fail...
April 19, 2017 at 4:20 pm
Here ya go:USE [ReportServer];
GO;
--View all of the SSRS jobs
USE [ReportServer]
SELECT
[Schedule].[ScheduleID] AS [SQLAgent_Job_Name] ,
.[Description] AS [Description] ,
[Catalog].[Name] AS [Report Name]...
April 19, 2017 at 4:13 pm
If you want to know when the subscription is scheduled to be run, look at the SQL Agent Jobs. Those are what are triggered to start a subscription. The names...
April 19, 2017 at 3:50 pm
April 19, 2017 at 11:16 am
April 18, 2017 at 3:39 pm
That is nice that you have a dedicated VM for testing. I imagine you have the databases set up so they are both running off of the same VM then...
April 18, 2017 at 10:47 am
Another thing you could do is look at HA software. Backups are more about DR than HA.
DH2i has a tool called DxEnterprise which handles HA quite nicely as...
April 18, 2017 at 10:24 am
Viewing 15 posts - 2,566 through 2,580 (of 2,855 total)