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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Why my backup not completed?

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 0

Please 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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -