Tran Log backups on FusionIO cards are 6 times larger

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Tran Log backups on FusionIO cards are 6 times larger

Postby timh@ucn.net » Thu Feb 14, 2013 8:30 pm

We added FusionIO cards to a database server. HP recommends changing the sector size from 512 to 4096 for SQL Server. We did that and moved our log files from DASD to the FusionIO cards. The backups are now 6 times larger but the database activity has not changed.

Has anyone else experienced this?
timh@ucn.net
 
Posts: 3
Joined: Tue Jul 18, 2006 5:03 pm

Postby petey » Fri Feb 15, 2013 12:55 pm

Could you please post the contents of a SQL Backup log file for the backup of a transaction log that grew in size?

The default folder where the logs are stored is C:\\Documents and Settings\\All Users\\Application Data\\Red Gate\\SQL Backup\\Log\\<instance name> on Windows 2003 and older, and C:\\ProgramData\\Red Gate\\SQL Backup\\Log\\<instance name> on Windows Vista and newer.

Could you also please post the contents of a log file for a transaction log backup prior to the switch to FusionIO?

Thanks.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2229
Joined: Sun Apr 24, 2005 12:34 pm

Postby ChrisAVWood » Fri Feb 15, 2013 11:22 pm

You might want to look at this KB http://support.microsoft.com/kb/926930
You didn't mention what version of SQL or O/S you were running?

HTH

Chris
English DBA living in CANADA
ChrisAVWood
 
Posts: 308
Joined: Tue Dec 18, 2007 6:18 pm
Location: Edmonton, Alberta, CANADA


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests