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 |
|
Mohamed4053
Starting Member
1 Post |
 Posted - 2014-12-25 : 11:57:54
|
| I am trying to take a sql server database back up on SQL 2008 . When it is scheduled to be backed up as part of a maintenance plan, the job starts to execute, but never finishes - it just sticks on executing. The same thing happens if I try to back it up manually. No errors are produced because the job never fails.•I am taking the backup in DataDomain(SAN)•Earlier the backup job was working fine.•I have is there any backup job running but nothing running.•There is no blocking. While running below query, SELECT session_id ,status ,blocking_session_id ,wait_type ,wait_time ,wait_resource ,transaction_id FROM sys.dm_exec_requests WHERE status = N'suspended';97 suspended 0 ASYNC_IO_COMPLETION 9099392 0Please let me know if you come across this situation.Note:- In that server, symantec antivirus is running on that machine. I suspect this may be a cause for this problem. But Want to confirm that.I post this question in another forum i didn't get any answer. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-12-26 : 13:05:16
|
| You need to add exclusions to your AVS software, such as exclude bak, trn, dif, mdf, ndf, ldf files. There are plenty more to exclude. Microsoft has a list. I don't have the link handy.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
|
|
Why my backup not completed?