“I’ll Wiki you my pretty… and your little script too!!” So I submitted my first Wiki article over at SQLServerPedia: Restoring a User Database to a Different Environment and I have to admit that when I first started thinking about it I was quite concerned about how to do it, whether the script is “wiki [...]
Posts under ‘Backup’
I am not the first DBA to take up this cause… but I am determined to be the last
OK maybe this article is not THAT important LOL but it was a great quote by Obama so I figured I’d work it in LOL Please know what Recovery Mode your databases are in and your recovery requirements and then back them up accordingly. Too often I see databases that are in a Full or [...]
SQL Databases That Have Not Had a Full Backup in x Days
So something that you should do regardless of the alerts, notifications, etc that you have setup is to just have a daily sanity check on your database backups. Sure you don’t have any failed jobs but what if the job never attempted to run in the first place like it was supposed to? If a [...]
Backup Compression Savings
A while back I wrote a post on SQL 2008′s Backup Compression where I took a sample database and performed a backup with and without compression being used and did some basic comparisons. So let’s say now you’ve been using SQL 2008 with the backup compression for a while now and would like to see [...]
COPY_ONLY Backups
In SQL 2005 a COPY_ONLY option became available for backing up your databases. What COPY_ONLY does is take a backup (full or t-log) without affecting the backup/restore cycle. This is a great new feature as quite often DBAs are asked for an out of sequence backup to be taken to restore to a different environment. [...]
