Hi Sue,

Yes, I understand that's how it works now, apparently since 2012.

I also found that the copy only option doesn't actually interfere with the backup chain...

Hi Beatrix,
I understand what you are saying, but this is not what is supposed to happen as a copy only backup should not interfere with the backup chain as...

Hi Beatrix,

No, the what I am saying is:

1, Full backup taken at 8am
2, Hourly transaction backups taken every hour there after up to 1pm.
3, An...

Hi Steve,

Yep spot on with your logic... So obvious now! ?? How embarrassing!

I thought I had got round the issue using database ID to exclude the system databases e.g ID...

Steve,

I gave your suggestion a go this morning, I found the following behaviour to be a bit strange and condusing:.

The requirement is to be able to create a policy to...

Hi Steve,
Thanks for replying, I will give your suggestion a go today and let you know how I get on.
Adam

Looking at the logs I can see entries for when the agent job has sent mail, but there is nothing for the MP at all... its just as if it...

Hi All,

I think I have this working but it seems really messy, any suggestions?

USE [My_Services]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[usp_Event_Table_Extract_List_Databases]

@LnkSQLServer VARCHAR(50)

AS BEGIN

DECLARE @LnkSQLCMD NVARCHAR(1000)

DECLARE @LnkSQLSrv NVARCHAR(1000)

DECLARE @DBState NVARCHAR(10)

SET @DBSTATE...

Thanks for the article link Ginga, I will continue to look around as well and update this post if I find anything.

I guess my safest option would be to leave...

Hi Greg,

Thank you for your comments and guidance, and yes I agree a calendar table probably will be mixed up into the solution before long 🙂

Kind regards,

Adam

Hi Jeff,

Thanks for getting back to me, and yes this requirement sounds simple to the humans doesn't it 🙂

Please see responses to your questions:

1. What is the first day of...

Hi Jeff,

No not at all, what I was after was a count of activity by week number over the year(s), and to display visually in a report which month and...

Hi Jeff,

I did try the ISO_WEEK option but I was still getting overlaps with the months.... which caused duplicate week number entries because I was grouping by the month in...

Hi Scott

Many thanks for your response, and great suggestion. I have managed to get round the issue (although not perfect) by pulling the week number and data first into a...

Hi Get me?,

Many thanks for your response, I agree the calendar approach would be the best. However, due to time constraints I have managed to get round the issue (although...