Learn the solutions for recovering a suspect MSDB database in SQL Server
SQL Server agent makes use of msdb database for the purpose of scheduling jobs and alerts by making use of other features like SSMS, database mail, and service broker. There can be situations where your msdb database is rendered suspect and is in need of recovery. Here you might think that a simple recovery action would be enough to bring the database back in health, but that is not true. Here you need to do ensure more...
Read more »
Learn about Hardware partitioning in SQL Server, why you should do it, how does it help
If you want to make it easier for yourself to make sense of your SQL Server databases along with easing down its maintenance process, then it is advisable that you partition your SQL Server databases. It is important to note that partitioning and splitting in SQL Server are two different processes, and for partitioning a database, you do not have to split it. Partitioning can be done by simply putting...
Read more »
Learn about the common risks and problems that your backed up data is facing, and how to deal with them.
Backing up data in SQL Server is surely something that you should do unfailingly, but that is not all that you need to do to keep data safe. Ensuring the safety of data in the backup is also an important point to consider. For all the different backup options that are available to you in SQL Server, you also need to keep in mind that they are being stored in clear text format, which can...
Read more »
