Database was 500Gb, 200 GB worth data deleted and then shrink files to reclaim space, backup was taking 2 hours before and still taking same time after database reduced to 200 GB
Then I agree. That's a problem and I've got no idea why that may be unless it's somehow throttled down by something else. Are you doing it as a single file backup or are you splitting the backup into multiple streams.
Also, 2 hours to backup even 500GB seems like a pretty long time to me. I'm backing up at a rate of about 2TB per hour from my prod box. I have to admit that it's got some pretty hefty connections to it and I'm using backup compression with special settings for buffers, etc, but there shouldn't be that much difference and, most certainly, your backups should not be taking the same time as they were, from what you've described.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)