Log Shipping - Exclusive access could not be obtained because the database is in use
This story began as they almost always do - with a page at 4am local time...
--
'Alert: SQL Failed Jobs on InstanceName...
2014-07-31
10,835 reads
Nebraska SQL from @DBA_ANDY
End of Mainstream Support for Microsoft SQL Server 2008 and 2008 R2
@DBA_ANDY: A reminder to all #sqlserver peeps out there and *especially* to our clients: #sql2008 #sql20008R2 http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/07/09/end-of-mainstream-support-for-sql-server-2008-and-sql-server-2008-r2.aspx#Ntirety
Original Message:
http://twitter.com/DBA_ANDY/status/488744595136999424
--
What does...
2014-07-14
10,333 reads
Why Is your datetime saved as a bigint anyway?
Yet another issue I had never seen before - thankfully this time I was able to find a relatively quick answer.
On...
2014-06-26
726 reads
Handling Perfmon Logs with Relog
In a recent situation, I was tasked by a client to check one of their servers which they believed to...
2014-06-03 (first published: 2014-05-29)
7,470 reads
Come to #SQLSAT307 in Iowa City!
June 6th & 7th in Iowa City - Friday precons & Saturday all day sessions! I will be presenting on Maintaining your SQL...
2014-05-23
660 reads
Why Won't My Clustered Instance Start?
Last weekend I had a client page me in the middle of the night (because, of course, these things always...
2014-05-21
2,621 reads
T-SQL Tuesday #54 - Interviews and Hiring
This month’s T-SQL Tuesday is hosted by Boris Hristov (blog/@BorisHristov) and his chosen topic is “Interviews and Hiring” – specifically interviewing...
2014-05-16 (first published: 2014-05-13)
2,467 reads
Help - I Need a List of my Maintenance Plan Jobs *and* Schedules!
UPDATE - Jason Brimhall (blog/@sqlrnnr) pointed out after reading this post that there is a more inline way to do a...
2014-05-07
7,784 reads
Speaking at #SQLSat307 in Iowa City!
I just received confirmation I will be speaking at SQL Saturday 307 in Iowa City on June 7th!
I will be...
2014-05-02
653 reads
Why Can't I Reinitialize My Subscriber?
I recently had a colleague request help with a replication problem he was having with a client. The client was...
2014-04-28
3,366 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers