February 22, 2016 at 5:30 pm
I found this problem... this is only during one log backup during week... from saturday night to sunday midnight, and only one database from 10, but this is most using in real time , but in this time is without work ( weekend are free ).. Another backup during week are ok in all databases.
I found that there is LCK_M_U, but couldnt find more, because this lock was fast ... i found only sa login , system process 45id and database id 0..
Also I found that this was started from few weeks ago after Windows update, update of storage backup system and sql server SP3. All updates without some problem during instalations.
i found this article http://troubleshootingsql.com/2012/07/03/concurrent-backups-what-is-the-big-deal/[/url]
anyone had same problem? any experience ? will wait till next saturday night and try to find more
February 23, 2016 at 1:15 am
What does DBCC CHECKDB say?
Check this post from Paul - http://www.sqlskills.com/blogs/paul/how-can-a-log-backup-fail-but-a-full-backup-succeed/
Igor Micev,My blog: www.igormicev.com
February 23, 2016 at 3:32 pm
Igor Micev (2/23/2016)
What does DBCC CHECKDB say?Check this post from Paul - http://www.sqlskills.com/blogs/paul/how-can-a-log-backup-fail-but-a-full-backup-succeed/
have to wait for weekend.
will check this post and after weekend will see. thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply