October 28, 2010 at 5:15 am
Hi all,
My databse size is 65GB While i am talking the full backup it takes 6 hours time .. what i need to do... please help in this ..
Have Great Day:-)
October 28, 2010 at 6:48 am
get a faster disk:-)
are you doing it when the server is idle?
October 28, 2010 at 7:19 am
Are you backing up to disks that are also used for other purposes ?
Backing up across a slow network ?
Buy 3rd party backup software.
October 28, 2010 at 12:41 pm
That's a very abnormally long time. I'd suggest taking a look at the sys.dm_exec_requests, just as a start, to see what is causing the process to wait, because it must be waiting on something.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 28, 2010 at 3:52 pm
Hello,
Check in the activity monitor if there are any constant wait types OR blocked transactions.
If it is a live OLTP database then plan this activity in off-peak hours.
Check what is the LOG file size and how much free space available in data file.
Also try taking backup on separate storage device like SAN etc.
Cheers
October 29, 2010 at 9:40 am
where are you backing up the database --locally or across a network?
Are you backing up when there is no/less users on the database?
You can back up using a 3rd party software tools...
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply