This blog is about another common error reported by many DBA to me. He faced error related to create file in OS.
Here is the text of the message.
SQL SERVER – 7 Important Things to Remember While Taking Effective Backup
An effective backup needs a tested restore plan as well as a schedule. I keep these seven reminders in recovery discussions.
SQL SERVER – Login Failed – Error: 18456, Severity: 14, State: 38 – Reason: Failed to Open the Explicitly Specified Database
Error 18456 State 38: failed to open the explicitly specified database. The login worked and the database did not. The four usual causes.
SQL SERVER – The Cluster Resource ‘SQL Server’ Could Not be Brought Online Due to an Error Bringing the Dependency Resource
Installing a second SQL Server 2012 instance on my Windows cluster failed: the cluster resource ‘SQL Server’ could not be brought online. Here is the fix.
How to Create Temp Table From Stored Procedure? – Interview Question of the Week #140
How do you create a Temp Table from a stored procedure when you do not know its result set? Here is the OPENROWSET approach I use, and its drawbacks.
SQL SERVER – Changing Cluster Domains with WSFC and SQL FCI Support Limits
To Move SQL Server Cluster installations between domains, I plan an application-specific migration. The Windows cluster capability alone does not establish SQL support.
SQL SERVER – AlwaysOn Availability Group Listener – This TCP Port is Already in Use
Creating an AlwaysOn availability group listener in SSMS failed with error 19486: this TCP port is already in use. Here is what the ERRORLOG showed.