Today we are going to discuss Reclaiming Space and Performance: Database Backup History. I figured out during Comprehensive Database Performance.
SQL SERVER – Reasons – Not Able to Shrink the Transaction Log
Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they could not shrink the transaction log.
SQL SERVER – What do These Messages Mean – “I/O is Frozen on Database” and “I/O was Resumed on Database”?
“I/O is frozen on database” and “I/O was resumed on database”? Did you check the air conditioner temperature? Let us learn about it in today’s blog post.
SQL SERVER – Details About SQL Jobs and Job Schedules
SQL Expert Dominic Wirth has written a very interesting script about SQL Jobs and Job Schedules. Let us learn about that in this blog post.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed – The Server Principal Owns One or More Availability Group(s) and Cannot be Dropped
In this blog we would learn about fixing error Script level upgrade for database ‘master’ failed because of upgrade step ‘’msdb110_upgrade.sql’
How to Create a Table Automatically in All Newly Created Databases? – Interview Question of the Week #238
Question: How to Create a Table Automatically in All Newly Created Databases? This question was recently asked in my recent consulting engagement
SQL SERVER – Upgrade Error: The Server Principal is Not Able to Access the Database “msdb” Under the Current Security Context
The Upgrade Error messages shown in ERRORLOG was “The server principal “SQLAuthority\AuthOwner” is not able to access the database “msdb”