Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1649
| X-Received | by 10.182.158.4 with SMTP id wq4mr1824070obb.18.1390957138309; Tue, 28 Jan 2014 16:58:58 -0800 (PST) |
|---|---|
| X-Received | by 10.140.85.179 with SMTP id n48mr74151qgd.6.1390957138230; Tue, 28 Jan 2014 16:58:58 -0800 (PST) |
| Path | csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!us.feeder.erje.net!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!news.ripco.com!news.glorb.com!c10no4494956igq.0!news-out.google.com!s3ni162qas.0!nntp.google.com!k15no9398121qaq.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail |
| Newsgroups | comp.databases.ms-sqlserver |
| Date | Tue, 28 Jan 2014 16:58:58 -0800 (PST) |
| In-Reply-To | <XnsA2C3E928BBD6BYazorman@127.0.0.1> |
| Complaints-To | groups-abuse@google.com |
| Injection-Info | glegroupsg2000goo.googlegroups.com; posting-host=92.40.21.115; posting-account=dELd-gkAAABehNzDMBP4sfQElk2tFztP |
| NNTP-Posting-Host | 92.40.21.115 |
| References | <a226b43d-9e59-4686-b21c-b818fed76ef8@googlegroups.com> <XnsA2C3E928BBD6BYazorman@127.0.0.1> |
| User-Agent | G2/1.0 |
| MIME-Version | 1.0 |
| Message-ID | <06522420-91a7-4905-8d4b-9d397a3eed68@googlegroups.com> (permalink) |
| Subject | Re: Transaction Log Backup Failing as Deadlock Victim |
| From | rja.carnegie@gmail.com |
| Injection-Date | Wed, 29 Jan 2014 00:58:58 +0000 |
| Content-Type | text/plain; charset=ISO-8859-1 |
| Xref | csiph.com comp.databases.ms-sqlserver:1649 |
Show key headers only | View raw
On Tuesday, 28 January 2014 21:55:13 UTC, Erland Sommarskog wrote: > Supposedly, it is not the T-LOG backup itself that fails, but what fails > is when the log backup is recorded in msdb, which is not known for its > optimal indexing. This blog post with a script from my fellow MVP Geoff > Hiten should help you. Is this what you meant to link to, again - "MSDB Performance Tuning"? <http://weblogs.sqlteam.com/geoffh/archive/2008/01/21/MSDB-Performance-Tuning.aspx> There is plenty to think about, there, anyway.
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Transaction Log Backup Failing as Deadlock Victim Mark D Powell <Mark.Powell2@hp.com> - 2014-01-28 12:58 -0800
Re: Transaction Log Backup Failing as Deadlock Victim Erland Sommarskog <esquel@sommarskog.se> - 2014-01-28 22:55 +0100
Re: Transaction Log Backup Failing as Deadlock Victim rja.carnegie@gmail.com - 2014-01-28 16:58 -0800
Re: Transaction Log Backup Failing as Deadlock Victim Erland Sommarskog <esquel@sommarskog.se> - 2014-01-29 08:34 +0000
Re: Transaction Log Backup Failing as Deadlock Victim Mark D Powell <Mark.Powell2@hp.com> - 2014-01-30 12:34 -0800
Re: Transaction Log Backup Failing as Deadlock Victim Mark D Powell <Mark.Powell2@hp.com> - 2014-01-30 13:07 -0800
csiph-web