“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 Tagged ‘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 [...]
SQL Server 2008 – Backup compression
Backup compression is something new to SQL Server in SQL 2008 and it’s something that products like SQL LiteSpeed will be quite interested. Using a sample database I ran the following scripts and listed the results below: DECLARE @StartDateTime DATETIME = GETDATE()BACKUP DATABASE <<DatabaseName>> TO DISK = 'D:\NotCompressed.bak' WITH INIT, COPY_ONLYSELECT DATEDIFF(ms, @StartDateTime, GETDATE()) SET @StartDateTime [...]
Backup Types in SQL Server
This post may not be the most technical or advanced dicussion but I think it’s important that everyone knows what is available within SQL Server and the differences between them. Full Backup – This is like it sounds a full copy of the databases. Full backups take the most time to complete but they are [...]
