Browse by Tags
All Tags
»
Backup & Restore
(
RSS
)
SQL Server 2005
SQL Server 2008 R2
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...
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...
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...
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...
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...
Home
Contact
DavidWimbush
Observations of a SQL Server DBA and Reporting & BI developer.
RSS
Atom
Comments RSS
Recent Posts
Strange gotcha with column names
SQL Server 2012 edition comparison details are published
Denali Side-by-Side Gotcha
An annoying problem with Nulls
Failing report subscriptions
Tags
Analysis Services
Backup & Restore
BI
Books
Community
Database Mail
Dependencies
Disaster Recovery
Functions
How Not to Do It
Indexes
Log Shipping
Management Studio
Performance
Reporting Services
Security
SQL Down Under
SQL Server 2005
SQL Server 2005 tempdb
SQL Server 2008
SQL Server 2008 R2
SQL Server 2012
SQLAgent
SQLBits
Strange but True
Tips and Tricks
Transaction Log
Upgrading
Archives
December 2011 (1)
November 2011 (1)
October 2011 (1)
August 2011 (1)
June 2011 (1)
April 2011 (1)
March 2011 (4)
February 2011 (1)
January 2011 (1)
December 2010 (2)
November 2010 (1)
September 2010 (2)
August 2010 (1)
July 2010 (4)
June 2010 (3)
May 2010 (4)
April 2010 (3)
March 2010 (3)
February 2010 (1)
December 2009 (2)
November 2009 (5)
October 2009 (2)
September 2009 (2)
August 2009 (1)
July 2009 (4)
June 2009 (4)
May 2009 (2)
Search
Go
Navigation
Home
Blogs
Photos
Downloads