Browse by Tags

All Tags » Backup & Restore (RSS)
07 May 2010
R2 and Idera Idera SQL Safe (Freeware Edition)
Good news: the Freeware edition of Idera SQL Safe works on R2. You might not care but I certainly do. Here's why: In September last year I started using Idera SQL Safe (the Freeware Edition) to get backup compression on my SQL 2005 servers. It seemed like a good idea at the time - it was free and... Read More...
no comments
Filed under: ,
22 November 2009
Is this log backup file the next one to restore?
When you restore from a transaction log backup, SQL Server checks the file against the database and gives you an error if the file is not the next one in the sequence. I wanted to know how this works so I did some digging. Not much in Books Online that I could see so I did some practical investigation... Read More...
no comments
Filed under:
10 November 2009
Idera discontinues SQLSafe Freeware Edition
No longer available for download. Check it out here: http://www.idera.com/Products/Free-Tools/SQL-safe-Freeware-Edition/ Bummer! I'm using this extensively. Now you have to choose between the Enterprise edition and the Lite Edition. The Lite Edition is $295 per instance, which is not quite as attractive... Read More...
no comments
Filed under:
24 September 2009
Backup compression on SQL 2005
Last night, after a lot of preparation, I finally flicked the switch on the backup compression solution I've been implementing. The results were dramatic but in a good way: backup jobs 60% faster 50% disk space saving Reporting & BI build 30% faster Reporting & BI ready 3 hours earlier than... Read More...
no comments
Filed under: ,
06 July 2009
Housekeeping backup and restore history
Every backup and restore event is logged in history tables in msdb and these tables can get out of hand, especially if you're using log shipping. Here's one way to sort it out that will catch up with the backlog and then keep your history tables trimmed. This code will delete the oldest days... Read More...
3 comment(s)
Filed under: