January 17, 2015 at 7:25 am
I am facing issue in one of my production server. Backup of a database appear suspended it is not progressing after attaining 99%completion. I restarted the sql service and again ran the backup for the db still it is getting suspended when it reached 99%completion. size of the db is 1 GB. It is in suspended state for last 6 days. iam facing issue in sql server 2008 enterprise edition. i need help on this and wait type is CMEMTHREAD
January 17, 2015 at 11:07 am
Strange. Just one database?
Have you tried something as simple as
backup database x to disk = 'test.bak'
and see if that works? Rebooted the Windows host?
I've never heard of this. I did see this, which doesn't seem to be related: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f13a3c50-0611-4af4-ae1d-efe41570a31b/cmemthread-seems-to-be-a-problem
January 18, 2015 at 2:23 am
yes, i am facing this issue for 1 database. i didnt try to restart the window. I thought restart of sql Service will resolve issue. when issue happened first time i tried backup statement and this session was blocked by the suspended session.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply