Is running repair on msdb safe?
Just saw this on a forum – running REPAIR_ALLOW_DATA_LOSS on msdb to cope with corruption. Yes, this will work but it's certainly not safe and
Menu
Just saw this on a forum – running REPAIR_ALLOW_DATA_LOSS on msdb to cope with corruption. Yes, this will work but it's certainly not safe and
(Yes, Kimberly's lecturing again…) Here's something that I've seen crop up a lot recently on corruption forums: Server: Msg 602, Level 21, State 50, Line
After teaching some of the MCM-SharePoint class last week, one of the attendees pointed me at a blog post about measuring churn in SharePoint databases.
Last week I kicked off the first weekly survey – on whether you validate your backups or not (see here for the survey). The results
This is an interesting case that cropped up yesterday – the transaction log is damaged so a log backup doesn’t work (with the error below):
I'm toying with the idea of having a weekly survey that'll highlight an interesting facet of database management. I've signed up with SurveyPopups.com, which is
OK – last content post today. I forgot that the February TechNet Magazine also has the latest edition of my regular SQL Q&A column. This
Here’s a question I got from someone who attended our database maintenance workshop at PASS last week (paraphrased): I attended your pre-conference session on database
This blog post explains the demo scripts and databases I've posted to cover all the Corruption Survival Techniques and DBCC CHECKDB sessions I've presented at
It's really scary how quickly time flies – seems like it was just last week when I last blogged about TechNet Magazine (actually it was
Today's post is based on a bunch of questions I've had around the various compression features in SQL Server 2008. Does turning on data compression
On Tuesday we had a look around our customer's data centers here in Austria – hidden away in the labryinthine bowels of a very large
It's been almost exactly a week since the last post – an unusually long time for me. Kimberly and I were teaching the first week
It’s been almost two weeks since my last post as we’ve been offline in Scotland (another photo post to follow – I owe you two
I woke up this morning and someone had replaced my wife with someone who likes to blog :-). Kimberly’s turned over a new leaf and is
Moving databases around is pretty common, as is moving databases between servers running different Editions of SQL Server, especially during a disaster recovery situation. You
There's been a spate of problems on the forums and in my inbox with people's transaction logs filling up. With the increase in "involuntary DBAs",
I've had a few follow-ups on my two posts about boot page and file header page corruption – asking if its possible to do single-page
As you may already know, instant file initialization is a way to prevent data (not log) file create and grow operations having to zero-initialize the
Well, we’re just back from vacation (photo blog post to follow) and I’ve heard that the feature article on Effective Database Maintenance I wrote for the
Over the last few weeks I've seen (and helped correct) quite a few myths and misconceptions about index rebuild operations. There's enough now to make
Over the weekend there was a question on one of the internal aliases at MS: how can I tell what percentage of a database has
Here’s an interesting question that came in to our questions line (questions@SQLskills.com – no guarantee of an answer – I check it every so often): I
Here’s a question that came in – what changed in SQL Server 2005 that allows concurrent log and full backups? First a little background, in
Phew – last week Kimberly and I spent 3 days teaching the ins-and-outs of SQL Server 2008 for DBAs/IT-Pros to about 130 Microsoft SQL Server
This post is based on one from my old MSDN blog but the topic has come up a few times in recent days so I
In a previous post (see here) I debunked a myth about how much transaction log a full backup would include. I had a question
Back in September last year I blogged about the native Backup Compression that is in SQL Server 2008 (see here) and promised to blog more
In the mail today I received notice that my first software patent has been granted by the US Patent Office :-) (after being filed 3.5
While we were in Barcelona we sat down with Richard Campbell and Greg Hughes from RunAs Radio to record a 1/2 hour interview on SQL
There’s a well known problem that every time a backup operation succeeds a message is written into the error log and Windows event log. If
I’ve been involved in a few conversations today that have highlighted some big misconceptions about how backups work. I’d like to use this blog post
After posting last week about a BACKUP feature that I don’t like (WITH NO_LOG – see here), I thought I’d do a quick post this
All the razzamatazz about new releases go on about what's new but hardly ever is there discussion of what's been removed. So that's the topic
This has come up several times over the last few days, and is something that Kimberly and I discuss (and deplore) when we lecture –
This is another question that came up on the Disaster Recovery forum on MSDN. Paraphrasing – ‘ I have a backup file containing full backups
It’s common knowledge that SQL Server copes with daylight savings time (DST) correctly so why should you care? Well, it’s not so common knowledge that at
Here’s a really interesting question that was in my search engine logs yesterday – if I have a transaction that runs and completes while a backup
This one’s a quickie. In the previous post I explained about database pages – their structure and some page types. Now I’d like to explain
Over the next few months I’ll be blogging a lot about new features that are coming in SQL Server 2008 for DBAs and ITPros. First
This was originally posted as two posts on the SQL Server Storage Engine site. It was very popular so I’ve combined the two posts together
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.