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. […]
PostDid you check your MSDB.dbo.suspect_pages after a database restore?
In SQL Server 2005, the default behavior of a RESTORE command is to simply continue even if there are corrupted pages in your backups. The only way to find out if there are corruptions is when a user gives you a call saying that they could not query some records and probably gets an error […]
PostYou 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 […]
PostAutomating SQL Server 2005 Express Backups and Deletion of Older Backup Files
I’ve compiled a couple of my scripts – both TSQL and VBScript – to create a tip for MSSQLTips.com on automating backups and deletion of SQL Server 2005 Express databases to mimic that of creating a database maintenance plan. You can check out the article for more details. Feel free to post comments on the […]
PostLazy DBA: Backup all your databases using a script
I have a compilation of scripts which I use on a daily basis to help me make my work a bit easier. I always mention during my presentations that the laziest people are administrators who happen to have a programming background. Here’s one that I frequently use. A message on my instant messenger popped up […]
PostYour poor-man’s SQL Server Log Shipping
Transaction Log Shipping is a disaster recovery (sometimes called data recovery) option in SQL Server where you generate transaction log backups in the source database, copy them over to a remote SQL Server instance and restore them in read-only, standby mode. This feature is available in Enterprise Edition for SQL Server 2000 while SQL Server […]
Post>I wish this was available years back – SQL Server 2005 Always On Technologies Part 2
>One of the most underestimated feature of SQL Server is the FULL RECOVERY model in the database options. Database recovery models determine how much data loss is acceptable in case of a failure and what types of backup and restore functions are allowed. This has been an option which you can trace back from the […]
PostI wish this was available years back – SQL Server 2005 Always On Technologies Part 1
In response to requests made after I did a presentation on Microsoft TechEd Asia 2007 on SQL Server 2005 Always On Technologies, I’ve made the content available on my blog. In as much as we want to, there are not as many options in SQL Server 2000 to address disaster recovery caused by human errors. […]
