Viewing 15 posts - 901 through 915 (of 7,466 total)
SOLUTION:
For DBMirroring to be able to use KERBEROS,
you need to register an SPN for the service account to the Endpoint port number !
February 20, 2018 at 2:37 am
I finally got this to work lowering AUTHENTICATION settings
..; FOR DATA_MIRRORING (
ROLE = ALL,
AUTHENTICATION = WINDOWS NEGOTIATE ,
...
February 20, 2018 at 1:26 am
This article has a pretty good checklist to run through for that error -...
February 20, 2018 at 12:36 am
February 20, 2018 at 12:30 am
February 19, 2018 at 5:52 am
it depends on the nature of the data.
If that data is to sensitive ( names / Social numbers / ... ) they could refuse the auth.
IMHO in all...
February 19, 2018 at 3:24 am
I liked the article until I read the content of the DTU calculation webpage.
At least the first 2 paragraphs are yours.
February 15, 2018 at 5:46 am
You can copy the data/tables from to your primary mdf file.
How? That depends on your current configuration.
If you post your databases DDL (create database statement) we may...
February 13, 2018 at 7:50 am
it actually performs the collation translation, and materializes that data in tempdb, so .... yes.
The only decent way around it, is to create a new db and its...
January 30, 2018 at 8:05 am
Check the "remarks" section and "Errors Unaffected by a TRY…CATCH Construct" in the try-catch documentation : https://docs.microsoft.com/en-us/sql/t-sql/language-elements/try-catch-transact-sql
January 18, 2018 at 3:43 am
No. local software is updated and scripts are provided to upgrade the db at startup (failover) time.
At startup (failover) time upgrades are being checked and executed if needed.
If...
January 15, 2018 at 3:44 am
( Starting with SQL2012, ) you could opt to move tempdb to a local drive on each node. ref: http://www.sqlservercentral.com/articles/failover/137066/
Each node has to be hotfixed ( cumulative...
January 15, 2018 at 2:00 am
As a picture says more than 1000 words: Statler & Waldorf ( and I hope everybody still knows the duo )
November 13, 2017 at 5:20 am
As a starter I always use the target versions Data Migration Assistant (formerly known as Upgrade Advisor ).
Have a look at https://docs.microsoft.com/en-us/sql/dma/dma-overview
November 9, 2017 at 12:14 am
Viewing 15 posts - 901 through 915 (of 7,466 total)