I’ve spent a couple of hours trying to troubleshoot a clustered SQL Server 2008 installation. All I know is that it throws this error message after the installation process and does not give me any clue at all The cluster resource ‘SQL Server (MSSQLSERVER)’ could not be brought online. Error: The group or resource is […]
I’ve done quite a few SQL Server 2008 cluster installations before which is why this struck me as a surprise. I was trying to rebuild one of my test mahines when I hit upon this error message while adding the second node on a two-node SQL Server 2008 cluster on a Windows Server 2008. The […]
Have you ever had the feeling that SQL Server was playing a trick on you? I had those moments. I was updating a database maintenance plan and ran the corresponding job associated with it. I got an error saying that the job owner did not have permissions to execute the task. So I did what […]
NOTE: I don’t really recommend shrinking database files unless it is really necessary. Have you ever wanted to shrink your log files but couldn’t do it no matter how hard you try? While I and the majority of SQL Server DBAs would not recommend shrinking the transaction log (or any data file in your database), […]
While this is not recommended especially when you’re a bit paranoid about disaster recovery and data integrity, I still find a lot of people doing it. I guess a lot of independent software vendors don’t understand the underlying concepts behind the database engine. While it may have worked in SQL Server 2000 using Enterprise Manager, […]