Forum Replies Created
Viewing 15 posts - 106 through 120 (of 9,244 total)
-
Reply To: Backup with Checksum Show No Issues, While DBCC CHECKDB Reports Errors
What errors did checkdb report?
how often do you run dbcc checkdb on your databases?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Can index fragmentation cause the database to enter suspect mode?
IT researcher wrote:My database was in suspect mode, and when I checked using DBCC CHECKDB, it returned errors.
As mentioned in the link below, I used the REPAIR_ALLOW_DATA_LOSS option with the DBCC...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: when primary is down and not accessible failover not occured then how to recover
with a busy 40TB db i would think the reason the AG does not failover immediately is due to the outstanding redo queue, it is multi threaded in later versions...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Are the posted questions getting worse?
Steve Jones - SSC Editor wrote:Perry Whittle wrote:in fact can’t we just have a copy of the code and db and go host our own solution maybe
If it were that easy, I would. The structure...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: when primary is down and not accessible failover not occured then how to recover
kmrao16-896944 wrote:It seems Question was incomplete.
If we consider Always ON ( Sync - Automatic failover) is on Windows cluster, Primary complete down is possible with Primary server switch off /...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: ghost backups processed 0 pages
Do you have the SQL iaas agent registered on the vm?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: DBNETLIB] [ConnectionOpen (SECDoClientHandshake()).] SSL Security Error
terry999 wrote:There is a firewall rule which only allows access via 1433 and 1434 UDP.
[\quote]
can this not be modified\updated to allow the named instance port
terry999 wrote:So I Switched off the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Alert For Blocking in Azure SQL Managed Instance
sql agent on MI offers less than unmanaged instances
Alerts on MI are created at the Azure resource level, check out alerts and diagnostic...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: getting logged in user name to the pc that running the report
sys.dm_exec_sessions has the login_name column and host_name column
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Alert For Blocking in Azure SQL Managed Instance
Azure SQL MI is restricted in what they support, alerts are generally configured on the MI settings in the portal
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Truncate tables where Referential Integrity exists
the code creates the drop commands and the create commands, it's for dev use so test it first to ensure it does what you require
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Power BI on Prem License Question
krypto69 wrote:Hi
We have an on prem power BI running on a physical SQL2022 enterprise box with SA. Working fine, and legal.
For DR reasons I am considering moving just the web...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: SQL Server error
can you supply a little more detail please on exactly what it is you're doing and any error numbers produced from the sql server error log.
Also, how often is DBCC...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: Are the posted questions getting worse?
Steve Jones - SSC Editor wrote:Jeff Moden wrote:Steve Jones - SSC Editor wrote:sales@ or marketing@ might get better traction. We have someone monitoring the webmaster email, but not 100% sure they'd do much more than send the emails to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Reply To: SSIS Connecting to Azure SQL Managed Instance w/ MFA
check the sql connection driver you are using, these links detail further
Or a system\user managed identity
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 15 posts - 106 through 120 (of 9,244 total)