Viewing 15 posts - 16 through 30 (of 36 total)
Thanks for that. There was a slight issue in that the day portion being returned was 2nd of the month for a date duration of 1 day - because 0...
March 28, 2021 at 5:48 pm
Thanks for the feedback. Yes, the initial restore was greatly slower as the files were initialised but the regular refresh is obviously using pre-existing files so there's no speed improvements...
January 26, 2021 at 4:19 pm
Thanks Grant. Yeah, that's what I thought re: a restoring DB.
I'll see if there are any infrastructure-level options available to us.
Thanks again.
January 26, 2021 at 1:00 pm
Note: I've managed to make this work by changing "pattern2" to:
pattern2 = "[\x22\x27\x2c\x3f\x5c\x5c\x60]"
but I don't know why I need to escape the backslash in the pattern2 value...
August 24, 2020 at 12:05 pm
Found the answer. On the secondary server run:
SELECT [secondary_id] FROM [msdb].[dbo].[log_shipping_monitor_secondary] WHERE [secondary_server] = N'SECONDARY' AND [secondary_database] = N'DBNAME'
June 7, 2019 at 6:54 pm
Turns out that the timeout setting for the data driven subscription is 30 seconds (default) and this is where the issue was occurring. Didn't realise that this is what was...
March 12, 2019 at 5:11 am
Alex. I had that thought but wasn’t sure if that would differentiate between the database being encrypted and the backup of the database being encrypted. Peter
May 29, 2018 at 1:08 pm
RESOLVED:
It turned out that the availability group was the issue. Looking at sys.databases I saw that the log_reuse_desc was AVAILABILITY GROUP so it was replication that was preventing...
April 18, 2018 at 8:44 am
Hmm... Changing this through the normal services interface worked. When I set the account to use I got a message stating that the "log on as a service" right was...
March 13, 2018 at 9:50 am
Hi Sue. Yes I am.
March 13, 2018 at 8:38 am
Sorry for the delay; forgot to update this.
This turned out to be a strange issue. The publication database had a number of duplicated foreign keys on...
October 31, 2017 at 5:09 am
Hi Phil. No, we're not using that setting and we do have schema changes enabled for replication.
September 26, 2017 at 3:25 am
Thanks. I've also been looking at the log files for this (SQLFT*.LOG) and notice in a previous rebuild that there were messages of the form:
Error '0x80043630: The filter...
September 8, 2017 at 5:48 am
Your article led me to https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-fts-population-ranges-transact-sql.
Do you know whether the "processed_row_count" value in this view is accurate? If so then it's only 26% complete and has 6 more...
September 8, 2017 at 4:05 am
So was I 🙂
There is a database role called "admin", for example, which has:
ALTER on schemas a, b and c
CREATE TABLE
CREATE PROCEDURE
What I'd like to do is restrict the "CREATE...
July 21, 2017 at 10:50 am
Viewing 15 posts - 16 through 30 (of 36 total)