Viewing 15 posts - 1 through 15 (of 54 total)
I have now restored the backup to completely different hardware and done a CheckDB and it was fine so the issue is very much with the Reporting DB MDF file...
May 19, 2022 at 1:09 pm
For reference, I've been referred to this article that infers that yes, a backup that is verified, check summed, and can be restored without error, might still be corrupt which...
May 19, 2022 at 12:28 pm
Interesting, and sadly, I actually cannot remember. I did drop the DB but can't remember if that was the first or second restore.
If we assume I didn't drop it and...
May 19, 2022 at 12:01 pm
Hi Jeffrey, this wasn't born out in testing.
Changing the File System Task from Move File to Copy File has the same problem
Also, manually copying manually moving the file didn't have...
October 22, 2021 at 2:10 pm
Replace all that with
SELECT FORMAT(GETDATE(),'yyyyMMddhhmmss')
October 22, 2021 at 11:08 am
Hi Brian,
I just tried that, but the file is still showing corrupted when viewed in OWA.
May 14, 2020 at 9:26 am
Its not am email client issue. I see the same corruption when sent to Gmail and viewing the attachment in Google docs. I also see the corruption if downloading the...
May 13, 2020 at 8:28 pm
Thanks Sue, I have already upped the attachment size to 10MB as some of my files are 4-5MB and I got the size error message at first. Its not related...
May 13, 2020 at 8:25 pm
After a little more noodling around, I think I refined (by trial and error more than skill) Brian's regex and came up with this which works
-[\s\S]*?-[\s\S]*?(?=- [0-3][0-9]\/[0-3][0-9]\/[0-9]{4})|[\s\S]*?(?<=\n)[\s\S]*
February 12, 2020 at 10:52 am
Thanks Brian,
That regex is close. It matches all the notes except the last one because it stops matching when it gets to the next date so the last note will...
February 12, 2020 at 9:49 am
If you no longer have your log backups, you can only restore to a full or differential backup. Point-in-time restores are only possible with log backups.
John
Thanks John, appreciate the...
September 30, 2019 at 1:41 pm
Scott.
That is the best example of double nesting Dynamic SQL with Output parameters I've seen even 9 years later. Just what I've been struggling with. Thank you.
September 9, 2019 at 12:22 pm
If anyone is interested, I figured it out.
This will dynamically give me columns for every combination of Category with Cost and Quanitity
DECLARE @Columns NVARCHAR(MAX)
DECLARE @sql NVARCHAR(MAX);
SET @Columns...
July 23, 2019 at 2:58 pm
Yes, I can totally do that, but I'm asking if it's possible to do it a single query.
My production query does a Dynamic Pivot using Dynamic SQL so I'd prefer...
July 19, 2019 at 3:36 pm
Thanks Drew.
I'm still testing this against my full production data-set, but it looks good. In fact, you solution appears far superior to mine as it handles overlapping groups and is...
July 1, 2019 at 8:24 am
Viewing 15 posts - 1 through 15 (of 54 total)