Search Results for “log shipping”

Mirrors aren’t backups

Last Updated February 9, 2017

Architecture, Backup and Recovery, Database Mirroring

Are you using any of these technologies as a method of database protection? Database mirroring (keeping two database servers synchronized with the same data via SQL 2005/2008) Replication (copying records between databases) Log shipping (copying log files to another server and restoring them immediately) SAN-based mirroring (storing two copies of your database on two different…

New StackOverflow database server coming

Last Updated February 9, 2017

Brent Ozar

Stack Overflow

SQL Server for StackOverflow Today, Jeff Atwood blogged about StackOverflow’s new SQL Server hardware: a Lenovo RD120, the artist formerly known as an IBM x346. Notice the big heart on the box. Servers run faster with love. Next, I’m aiming to do log shipping from the box pictured here over to Amazon S3. The StackOverflow…

Spring SSWUG Virtual Conference

Last Updated September 5, 2009

Brent Ozar

Ah, spring – that time of year when young men’s thoughts turn to T-SQL. The next SSWUG V-Conference will be April 22-24th, and I’ll be giving a few sessions: Log Shipping To The Cloud (300-level) In an ideal world, we’d have a standby SQL Server in a disaster recovery datacenter, but we can’t always afford…

Getting Started with Amazon EC2 SQL Server 2005

Last Updated February 13, 2017

Brent Ozar

Amazon Web Services (AWS)

Sometimes you need an offsite database server in case something goes wrong, but you can’t afford a full-blown disaster recovery datacenter. Or maybe you’ve got some ideas that you’d like to try out with a big SQL Server 2005 box, but you don’t have the hardware sitting around idle. Or maybe you’d just like to…

Amazon EC2 will offer Windows hosting

Last Updated February 13, 2017

Brent Ozar

Amazon Web Services (AWS)

A lot of cool things are happening at PDC this year, and Amazon’s already showing their cards: Amazon EC2 will offer Windows hosting. That means you can turn on a brand new Windows machine – or ten – and pay by the hour according to the capacity you’re using. Less than a dollar an hour…

Back up your database to the network – not local disk

Last Updated July 16, 2019

Brent Ozar

Backup and Recovery

Database administrators: are you backing up your SQL Servers to local drives? If so, you need to stop for a minute to think about a few possible side effects, and maybe think about backing up to a network share instead. Why? I’m glad you asked! Get your data off the server faster The only reason…

LiteSpeed v5.0 is out!

Last Updated September 5, 2009

Brent Ozar

Presto chango, version five. This one was in the oven long before I arrived at Quest back in May, and I’ve been using it for the last couple of months. Some of the big improvements are the ability to query backup files just like databases, the Backup Analyzer that automatically tests a bunch of compression…

Microsoft DPM 2007 review

Last Updated February 13, 2017

Brent Ozar

Backup and Recovery

I spent some time last week digging into Microsoft Data Protection Manager 2007, Microsoft’s solution for SQL Server backups, and I’m going to share some of my findings here with you, dear reader. “But You Work For Quest Software! You can’t write a Microsoft DPM review!” Yeah, disclaimer time – I work for the people…

Quest LiteSpeed isn’t right for everybody

Last Updated October 23, 2009

Brent Ozar

Sean McCown at Infoworld wrote a blog post today that said some negative things about Quest and LiteSpeed, and I had to respond. He’s switched away from using LiteSpeed, and he had an interesting set of reasons. “I just don’t need the centralized repository in my lab, and I do enough demos that having native…

SQL Server Backup Software: Part 1 – Why Native SQL Backups Suck

Last Updated February 13, 2017

Brent Ozar

Backup and Recovery

Before we start looking at SQL Server backup compression software, we need to spend a few minutes looking at the weaknesses of the native SQL Server backup process. In order to judge the fixes, we have to know what’s broken. Native SQL Server backups take the same disk space as the data. When we back…

SQL Server Backup Best Practices

Last Updated September 18, 2017

Brent Ozar

Backup and Recovery, SQL Server

I’ve been backing up SQL Servers for almost a decade now, and it’s time to share the lessons I’ve learned. All of this is my own opinion – your mileage may vary – but I’ll try to explain the reasoning behind the choices I make. I won’t address log shipping or snapshots this time around.…

PASS Summit 2007: Day Two Notes

Last Updated February 9, 2017

Brent Ozar

#SQLPass

Tom Casey: Keynote Tom covered basic SQL Server marketing slides about the BI stack. Yawn. Good presenter, but couldn’t overcome the dry material. Then he handed it off to a Dell woman to announce that they’ll be selling packaged BI solutions with hardware, software, storage, etc all in one bundle. They’re targeting customers in the…

[Video] Office Hours: 25 Pretty Good Questions

Last Updated April 26, 2023

Brent Ozar

Videos

You post questions at https://pollgab.com/room/brento and upvote the ones you’d like to see, and my job is to come up with accurate answers on the fly. Let’s see how I did. Here’s what we discussed: 00:00 Start 03:25 SickOf: Brent is there a backup product you can recommend? 04:38 OneEyebrowRaised: I’m noticing three significant shortfalls…

[Video] Office Hours: Ask Me Anything About SQL Server

Last Updated February 8, 2023

Brent Ozar

Videos

Y’all post and upvote questions at https://pollgab.com/room/brento, and I stream sessions on my Twitch.tv channel where I answer ’em and chat with the audience. 00:00 Start 02:09 Chad Baldwin: Hey Brent! “a friend told me” MSSQL will use an index’s stats to generate a plan, but not use the index itself. 03:25 Jeremiah Daigle: Hey…

How Do You Test IOPs, Latency, and Throughput?

Last Updated December 7, 2021

Brent Ozar

Storage

You’ve heard these terms thrown around about storage, and you’re not sure what they mean, and how they relate to each other. Let’s make it simpler by using an analogy. Say you want to measure a shipping company. You’re trying to decide whether to use DHL, FedEx, UPS, or your local postal service. You could…

Is Microsoft SQL Server 2022 a Big Release?

Last Updated November 11, 2021

Brent Ozar

SQL Server 2022

Normally when y’all post questions here on Pollgab, I let ’em pile up and I eventually do an Office Hours webcast where I talk through my answers. I check in on the list every couple of days just out of curiosity, though, and one of ’em jumped right out at me. The question, posed by…

How My Attitude and Branding Changed Over 20 Years

Last Updated March 30, 2021

Brent Ozar

Professional Development

This month, to mark the 20th anniversary of BrentOzar.com, I’m stepping back and looking at the big picture rather than blogging about database problems & solutions like I usually do. It wouldn’t be a good navel-gazing series without a couple thousands words looking inward at myself. When I first got started writing online, I was…

Interesting Undocumented Tidbits in SQL Server 2019 CU2

Last Updated February 19, 2020

Brent Ozar

SQL Server 2019

SQL Server 2019 Cumulative Update 2 is out, and Microsoft snuck in a few things that they didn’t mention in the release notes. Contained Availability Groups continue to get new investments. In the lead-up to SQL Server 2019’s release, we got a few presentations at various conferences where Microsoft folks said we’d get the ability…

The “Guess the Next Release Date” contest continues…

Last Updated March 1, 2019

Brent Ozar

SQL Server 2019

Back in December 2017, when I posted the Guess the Next SQL Server Release Date Contest, you could leave your guess in the comments for a chance to win a Live Class Season Pass and a Recorded Class Season Pass. Here’s how the guesses so far have gone – and for this quick analysis, I’m only…

[Video] Office Hours 2018/2/14 (With Transcriptions)

Last Updated February 17, 2018

Brent Ozar Unlimited Team

Videos

This week, Brent, Tara, and Richie discuss the lack of backward compatibility for SQL Server backups, deploying SQL Server on VMs with shared SAN storage, query tuning, replication, full-text indexes, backup and restore, saying “no” to your superiors as a DBA, clearing your transaction log, and much more. Here’s the video on YouTube: You can…

Search Results for “log shipping”

Hi! I’m Brent Ozar.