A client’s ERRORLOG showed database mirroring error 1474, ‘The specified network name is no longer available’. The cause was outside SQL Server.
SQL SERVER – Unable to Bring Resource Online – Error – Could Not Find Any IP Address that this SQL Server Instance Depends Upon
A clustered SQL Server could not find any IP address it depends upon, so it would not start. Here is how to fix it and bring the resource online.
SQL SERVER – Performance Choice – Coding or Automation
We love tweaking code, but is it the best use of our time? A look at Performance choices between coding and automation, and the ROI each one brings.
SQL SERVER – Fixing Annoying Network Binding Order Error – Notes from the Field #112
Ryan Adams explains a critical SQL Server error about network binding order and shows how to fix it in this Notes from the Field episode.
SQL SERVER – FIX – A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. (Microsoft.AnalysisServices.AdomdClient)
I opened SQL Server Management Studio and instead of a database engine. Below is the error which I received for SQL Browser:
SQL SERVER – Running Batch File Using T-SQL – xp_cmdshell bat file
What is xp_cmdshell used for, and how do you run a batch file using T-SQL? Examples run a system command, a plain BAT file and one with a parameter.
SQL SERVER – De-fragmentation of Database at Operating System to Improve Performance
Why does de-fragmentation of database files at the operating system level skip MDF files? SQL Server has them open, so stop the services first.