DB Backups taking hours

Question

DB Backups taking hours

reddykalpana02

Valued Member

Points: 60
More actions
September 11, 2014 at 10:14 am

#293163

Hello,
We are using sql server 2012 and backups are taking around 7hrs. Data base size is around 300GB and am taking backups with compression. There is no blocking but i see back up process is suspended due to wait types such as Asynch_io_completion, backup_buffer , backupIO.
Please help me with this. I have no idea how to solve this.
Appreciate all your help.
Thanks,
Kalpana

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 1

Sounds like something got frozen. I haven't seen this specifically, but 7 hours seems long. Is your IO subsystem slow? Can you copy 300GB in less time?

If so, I might restart the instance and manually run the backup.

F. van Ruyven SSCommitted Points: 1507 More actions · Answer 2

Is it a filestream database? In my experience, such a db with many small files is slow in backup.

reddykalpana02 Valued Member Points: 60 More actions · Answer 3

Hello,

I tried to copy a file of 288GB and it took around 3hrs 30mns. Do you think its a IO or disk issue?

Thanks for replying

Kalpana

reddykalpana02 Valued Member Points: 60 More actions · Answer 4

Hello,

How to find if it s a file stream data base?

Thanks for replying

Kalpana

crow1969 Hall of Fame Points: 3001 More actions · Answer 5

Check the filegroups for the database. Most databases (at least the ones in this size range) have just primary and Logs, but a filestream database will have a filegroup for the Filestream data.