October 15, 2009 at 1:01 am
In my Comapny having 180+ gb sized Database , everyday we need to backup the database , While backuping the database it takes morethan 2 to 2 and half an hour.. Sometime it stopped autometically without backup..
Please give me a soluitons for making faster backup the database...
Thanks in advance.........
October 15, 2009 at 1:36 am
Backup speed is almost entirely limited by disc throughput speed so you need to uderstand the limits of your disc system. Some suggestions and places to look:
a) Backup always to a different disc(s) to the database
b) When installing the hardware have a good read on "diskpart" and articles that describe it to get the optimum partition alignment.
c) 64k NTFS cluster size for the data files
d) Fast disks - you did not say if these were locally connected or san...
e) Raid level- 5 bad - 10 good (gross generalisation but should be accurate in this context)
f) Can you use striped backups?
g) Do you have to do a full backup daily - would a diff not be adequate?
Please post back more details of the hardware config and many people could then give more suggestions.
Mike
October 15, 2009 at 1:38 am
you should look for 3rd party backup tools
Regards,
[font="Verdana"]Sqlfrenzy[/font]
October 15, 2009 at 4:12 am
Saravanan_tvr (10/15/2009)
Please give me a soluitons for making faster backup the database...
Several options
Are you backing up to a network location? If so, backup to local disk
Check the performance stats on the drive the data files are on and the drive you're backing up to, see if they're overloaded.
Make sure you're backing up to a different drive than the database is on (common sense really)
Stripe the backup over multiple drives (but note that you need all the stripes to restore)
Don't do full backups every day, but do fulls once a week and differential backups daily
Consider an upgrade to SQL 2008 which has compressed backups or buy a 3rd party backup tool that does compressed backups.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply