Viewing 15 posts - 1 through 15 (of 5,418 total)
Jobs, logins, linked servers, audits, server triggers anything at the server level which is not done as part of backup restore of the user dbs.
Take a look at dbatools and...
October 27, 2020 at 7:19 am
As it's multi subnet DNS will have two or more entries depending how many subnets you span, so it's essentially picking the wrong DNS entry to ping as it will...
October 27, 2020 at 6:50 am
Google or your favourite search engine is your friend.
20598 - row not found at subscriber,
0x07.... means if your running SQL7 or above
October 27, 2020 at 6:46 am
Nothing that is 100% certain.
You would be best setting up some sort of extended event trace to capture all incoming queries then shredding the sql_text value to find the objects...
October 15, 2020 at 8:20 am
You will need to have a process to sync your on-prem ADFS to AAD with something like "Azure AD Connect Sync", then you would create the AAD account using the...
October 15, 2020 at 7:40 am
I would check the index usage stats to confirm if its getting any use and if it is scrape the query plan cache for anything which uses that index to...
October 14, 2020 at 5:20 pm
Because your using string literals to represent a datetime format.
CONVERT(VARCHAR(6), '2020-09-23 00:00:00.000', 112)
The above is taking a string and converting it into a 6 character string.
October 12, 2020 at 2:40 pm
The command is somewhat incomplete, it is missing the correct syntax near move for the log file.
It should be something more like this
USE [master]RESTORE DATABASE [MyDB]FROM DISK...
September 21, 2020 at 7:52 am
Whats the growth amount of the transaction log?
How many VLF's does the transaction log have?
If theres more than the usual recommended amount of VLF's (over 512) then you need to...
September 4, 2020 at 7:32 am
You would have to set the connection application intent to readwrite for the application and readonly for SSRS and ensure you have the proper read only routing setup in the...
September 4, 2020 at 7:29 am
Well you could just break it and have a 1 node AOAG cluster that way you dont have to mess around in DNS. We all know every trouble starts with...
September 4, 2020 at 7:24 am
Have you actually installed MICROSOFT SQL SERVER here and not MYSQL? Just looking at the server name MYSQL1100 would suggest you need to use MySQL Workbench and not Microsoft SQL...
September 3, 2020 at 10:52 am
Also as a side note I would recommend reading up on the BBCodes and extra formatting here to help people out and readily consumable data, you did a great job...
August 28, 2020 at 1:01 pm
So if I understood right, a script to run on a Saturday, to update fields for the next Mon-Fri?
If so you need to work out the "next monday" and use...
August 28, 2020 at 12:58 pm
Have you checked the default trace to see if anything its being logged as to what is removing it?
Cant fully remember if replication is logged to the default trace but...
August 28, 2020 at 8:18 am