Welcome to this new series -- in this column, I hope to impart some quick, short tips that will help you make quick work of managing and administering your SQL Server databases. First up is an ...

So I recently aquired a few SQL Server 2000 boxes to admin, and I really don't have much experience with the platform. I've been looking at backup options, and it seems that there's 3 options.

As you can see, traditional database backup and Zetta's DataProtect service featuring ZettaMirror are really 2 totally different ways to do SQL server backup and recovery. If you're ready to try the ...

Microsoft SQL Server 2000 comes with its own backup and recovery utilities. Though they work, there are a number of annoying limitations. For instance, you can't back up directly to a UNC path, and ...

CAMBRIDGE, United Kingdom--(BUSINESS WIRE)--Red Gate Software has released a new tool called SQL Object Level Recovery Native that enables individual database objects to be recovered from native SQL ...

Q: We use a lot of distributed transactions and we are now investigating database mirroring to provide high availability to one of our critical databases. During our testing, we discovered that ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

A free tool from Microsoft can make backing up data in Windows Server 2008 R2 efficient and almost hassle-free. Here's how to use it effectively. Back in the day, Microsoft's free backup tool was the ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...