Viewing 15 posts - 181 through 195 (of 9,244 total)
.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2024 at 4:27 pm
Hi All,
We have 2 x physical servers with windows server installed connected to a SAN via iSCSI.
We then have Failover Clustered Instance (FCI) setup across the 2 physical servers...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2024 at 4:27 pm
Likely referring to a MSMQ service in the database, query the catalogs to find out which, the following should help
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2024 at 4:13 pm
Definitely don’t restore SMKs across instances, they’re designed to be unique amongst instances and if you have existing objects protected by the original SMK then you lose those.
To downgrade the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2024 at 4:11 pm
I think we’ve all been there at some point in the past.
As stated you have the risk of security issues arising, undiscovered software issues, aging hardware and OS, etc.
Remaining within...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2024 at 11:54 am
I’ve used it in the past and it works but there are better dedicated products available but cost is the issue generally
CDC doesn’t play nicely with certain features such as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2024 at 11:42 am
If you’ve referenced DMA report and successfully changed and tested in dev and test then you have good level of assurance for prod change. You can always set it back...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2024 at 10:47 am
Not relative to the amount of data, features support is primarily your concern
if you’ve successfully tested in dev and test then apply to prod
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 26, 2024 at 9:33 am
Would strongly advise not to enable that account
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2024 at 8:13 pm
What’s the full error for the login failure, err number, severity and state
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2024 at 7:48 pm
I created sysadmin user xxx . Now the wizard gives me this error:
Login failed for user 'xxx'
Which is funny because I am logged in as that...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2024 at 5:36 pm
As a test, try a sql account on the server where you’re attempting windows auth
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2024 at 3:51 pm
Case by case scenario, running DMA pre migration will pinpoint issues
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2024 at 1:44 pm
Start by referencing this KB article, also use DMA to highlight issues when moving from one sql platform\version to another
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2024 at 1:24 pm
The below code works for backup files only from local drives.
When replaced with a network path the code just runs through but does not restore any dbs.
SET @backup_path='\\ABCD\E$\BackupsTest\' ;...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2024 at 12:44 pm
Viewing 15 posts - 181 through 195 (of 9,244 total)