thanks anthony

i have used 15/12/0 and will see how it goes

we have very basic queries being run by analysts, no extended sp's and some basic SSIS packages and a SSAS...

ooh....so i will convert my percentages into numbers

do the percentages look OK as a starting point?

I cant take memory away from SQL but i can play with SSAS as...

sorry....total must be less than hard....so:

HARD = 25

TOTAL = 20

LOW = 10

the current logic, to avoid individual jobs per database, is to go to the next database restore if the current one fails.

this always results in the job showing success but...

thanks

i know this.....but i still have to provide something they will be happy with

thanks

i could tune most of the reports....i would never let a report run on live for more than 5 minutes anyway if i can avoid it

the business doesnt want to...

oh....and there is no requirement for resilience, HA, standby or failover actions for this

it is purely for reporting

is there a better way to replicate the data changes to a standby...

thanks kevin

the reason log shipping is now becoming unusable is the want to drop the restore window to 15mins. it could take 5 mins to restore the log and standby...

im way off that level of experience but i always imagined it would be a pathway to a CTO, director or technology or similar position in company reliant on sql...

can use this query to match jobs and schedules

select

c.name [SSRS Report Name],

sj.name [SQLAgent Job Name],

c.itemid [SSRS ReportID],

sj.enabled [SQLAgent Job Status],

rs.scheduleid [SSRS SubscriptionID]

from msdb..sysjobs...

thanks....im hoping this wont be a regular thing....services was stopped due to a power down of the office building and SSRS was delayed until log shipping had caught up for...

ok thanks....ill check it out and give it a test

most of our schedules are independent but that could be changed to make this easier

ah ha!!

so if we are to turn off the SSRS service we need to disable all SQL Agent SSRS jobs??

is there no way to do this through SSRS??

thanks

OK....i have run a simple test (select getdate()) and can confirm that SSRS will rerun missed subscriptions.

- created a very simple report to output to a file (filename appended)

- set...