Red Gate forums :: View topic - Tran Log backups on FusionIO cards are 6 times larger
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Tran Log backups on FusionIO cards are 6 times larger

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
timh@ucn.net



Joined: 18 Jul 2006
Posts: 3

PostPosted: Thu Feb 14, 2013 8:30 pm    Post subject: Tran Log backups on FusionIO cards are 6 times larger Reply with quote

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?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2299

PostPosted: Fri Feb 15, 2013 12:55 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Fri Feb 15, 2013 11:22 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group