Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itsonlyme4
Posting Yak Master
109 Posts |
 Posted - 2015-02-18 : 18:00:23
|
| SQL Server 2008 r2 - 6 GB memory I attempted a backup on a 500GB database but it was taking way too long. I checked the resources on the box and saw the CPU at 100%. I checked the SQL Server activity log and saw a hung query (user was not even logged on) that had multiple threads so I killed it and now the CPU utilization is back to normal. Trouble is, now all of the threads in the activity monitor for the backup show 'suspended' and the backup appears to be not doing anything. Can anyone help? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-02-18 : 18:07:39
|
| Did you try killing those spids?Did you add the compression option to your backup command?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
sql server 2008 backup running long