Category: SQL Server Disaster Recovery

>Broken BACKUP and RESTORE sequence?

>Have you ever had the to scratch your head because your database backups won’t work even if you are practically sure that you have tested them properly? Imagine this – you have a regular FULL and DIFFERENTIAL database backups working together as part of your backup process. Your FULL backups run every Sunday and your […]

>So you can recover from database snapshots…but…

>SQL Server 2005 has given us the option to create database snapshots to create a point-in-time image of the database. This gives us the option to restore from a point-in-time in case of user errors, like maybe accidentally truncating a table. MSDN has provided us a procedural approach on how to restore from database snapshots. […]

>You don’t trust your database backups? Use mirrored backup media sets in SQL Server 2005

>What could be more frustrating than knowing that your database backups went missing? This is specifically true if you are dealing with transaction log backups which are dependent on log sequence numbers. You don’t want to lose a single transaction log backup in the chain. In previous versions of SQL Server, we just execute a […]

>You need to backup the mssqlsystemresource database files

>So, you think you have all the necessary database backups you need? Well, think again. This might be your mindset after moving from SQL Server 2000 to SQL Server 2005. SQL Server 2005 includes a read-only, hidden database that contains all the system objects. It comes in the form of mssqlsystemresource.mdf and mssqlsystemresource.ldf files located […]