Nov 4, 2010 | Backup, SQL Server 2008, SQL Server Internals, SQLServerPedia Syndication |
I got asked a question today that I though was quite interesting. If my backup starts at 6pm and it runs for say 30 minutes what happens to the transactions that occur during the 30 minutes that the backup is running? The short answer: All committed transactions that...
Apr 15, 2010 | Backup, SQL Server 2005, SQL Server 2008 |
To continue my little blog series on SQL Server backups, any series would not be complete without a look at some of the third party products that exist to supplement a backup plan with additional functionality not always offered in the native SQL Server backup. My...
Apr 4, 2010 | Backup, Recovery, SQL Server 2008 |
My last few posts have been backup orientated, I have a post on Full Backup, a post on Transaction Log backups and a note on how to manage backup files. The next in my little series on backups is a short post on differential backups in SQL Server.What is a...
Mar 29, 2010 | Backup, Scipts, Scripts |
I have seen many forum posts asking how do you schedule backups for SQL Express databases and the answers always have similar responses that go something like: “There is no SQL agent in Express…the only way to backup databases on a schedule is to write a script and...
Mar 23, 2010 | Backup, Scipts, SQL Server 2005 |
I recently posted a couple of scripts that backup all databases on your SQL Server instance to disk with a date and time stamp, so you know from the file name when it was taken and hopefully helps you identify how useful those backup are to you. The second...
Mar 21, 2010 | Backup, Scripts, SQL Server 2005 |
My last post showed a little script that I use for taking full backups of all my databases on an Instance.This script below will take a transaction log backup of all your database in full recovery mode, again it can be used in conjunction with the SQL agent to...
