Viewing 15 posts - 1 through 15 (of 92 total)
DBATools is awesome for this: Invoke-DbaDbClone
November 21, 2024 at 4:35 pm
About the only time I see something like this is when I grabbed the wrong backup (an older one). You are certain you grabbed the correct backup file? Did you...
August 28, 2024 at 2:34 pm
If the issue isn't DNS it's probably a Kerberos\SPN issue:
You can use the MS Kerberos tool to check it:
https://www.microsoft.com/en-us/download/details.aspx?id=39046
Also, is the SQL Browser Service running?
July 15, 2024 at 2:04 pm
Shouldn't it be IP, port (comma not colon) ?
July 8, 2024 at 4:23 pm
Rollbacks are single threaded so it can take much longer than than the parallel operation that got you there.
May 10, 2024 at 9:39 pm
I would give 'dbcc updateusage' a try. I can tell you this has fixed weird disk performance on new servers for me more than once.
May 3, 2024 at 6:22 pm
#1. Since nobody has responded, I'll offer maybe a bump in the right direction. I've found SPN's are very important to SSRS. I'd make sure you have a domain account...
April 22, 2024 at 2:14 pm
In AD, did you give the service account the 'Trust for delegation' property?
February 26, 2024 at 7:22 pm
https://dbatools.io/ - makes this very simple
You can use 'Sync-DbaLoginPermission' (everything) or 'Export-DbaDbRole' (to get role)
December 6, 2023 at 4:35 pm
Shrink it in smaller chunks.
Google for a script to reduce it incrementally.
https://www.sqlservercentral.com/blogs/sql-database-incremental-shrink-tsql
November 20, 2023 at 5:45 pm
Shrink it in smaller chunks.
Google for a script to reduce it incrementally.
November 20, 2023 at 5:44 pm
I'm now up to 10 failovers with no sync issues. I'm also on CU22.
October 12, 2023 at 8:52 pm
I hate to possibly jinx myself, but I've had 5 failovers with no secondaries out of sync. I've turned on ADR for a bunch of my databases. Maybe about 60...
October 2, 2023 at 4:33 pm
You probably lack the SPN's for SQL server. You can check them with the Microsoft tool: https://www.microsoft.com/en-US/download/details.aspx?id=39046
The tool can even generate the commands to add the missing ones.
September 11, 2023 at 2:16 pm
Maybe install the Kerberos diag tool and see if it checks out: https://www.microsoft.com/en-US/download/details.aspx?id=39046
The SSPI error is usually associated with missing SPNs.
August 23, 2023 at 4:12 pm
Viewing 15 posts - 1 through 15 (of 92 total)