Here’s a quick reminder for those of you using log shipping, and checking the SSMS report “Transaction Log Shipping Status” to assure you that your log shipping is up to date: that report is not always accurate. (I’m looking right now at a report that claims Database1 hasn’t been restored on the target server in […]
Category: sql server
Are you a functional DBA?
I’ve worked with SQL Server long enough to have interacted with several hundred database professionals, one on level or another. I’m going to take that as license to tell you this, one internet friend to another: You’re probably not the DBA you think you are. Junior If you’re just starting out as a DBA or […]
A Quick Guide to Expanding Database Files and IFI
This is a topic that’s been well covered, but in the interest of spreading good database practices, here’s a very quick note on instant file initialization (IFI) and database files. (As always, you should read the fine print – meaning Microsoft’s documentation – before you do anything on a production system.) Instant File Initialization IFI […]