One of the most common questions asked about SQL Server has to do with the transaction log and why does it grow. James Rea brings us a good explanation here of what happens and what you should do about it.  Read more...

In this sponsored article from Cloudberry, learn how you can backup your SQL Server data to the Amazon EC3 cloud.  Read more...

Testing and analysis of new backup compression and table/index compression features of SQL Server 2008.  Read more...

Should rolling back a restore be an option for SQL Server? Steve Jones talks about the possibilities in today's editorial and where it might come in handy.  Read more...

Question: My backup strategy is a daily full backup at 1 a.m. and a log backup every hour. A DBCC CHECKDB also runs every day at 4 a.m. If I get to work at 8 a.m. and discover that the nighttime consistency checks found extensive corruption, how can I recover without losing a lot of data?  Read more...

As databases get larger, the time for database backups to complete grows as well. Unfortunately, the time window for your backups may not increase. It could very well be the case that you reach a point where your backups will not finish in a specified amount of time.  Read more...

One of the core things a DBA must do is ensure backup and recovery of data. This Friday Steve Jones asks about your tolerance for safety and backup data in a Friday poll.  Read more...

In this post, we will look the steps to backup a SQL Server Analysis Server Database. After logging to the Analysis Services, in...  Read more...

How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.  Read more...

How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.  Read more...

How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.  Read more...

How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.  Read more...

A recent crash of the popular Coding Horror blog brings the responsibility of backups to the front of today's editorial. See if you agree with Steve Jones and his take on backups and restores.  Read more...

A recent crash of the popular Coding Horror blog brings the responsibility of backups to the front of today's editorial. See if you agree with Steve Jones and his take on backups and restores.  Read more...

A recent crash of the popular Coding Horror blog brings the responsibility of backups to the front of today's editorial. See if you agree with Steve Jones and his take on backups and restores.  Read more...

A recent crash of the popular Coding Horror blog brings the responsibility of backups to the front of today's editorial. See if you agree with Steve Jones and his take on backups and restores.  Read more...

The size of databases have been growing in such a way, it sometimes is hard to have a single drive / tape to...  Read more...

One of the very common things that is needed in SQL Server is performing a restore of a database. It's also one of the most important things that needs to take place. So why isn't this a simpler process? Steve Jones wonders why we can't make this a simpler process.  Read more...

One of the very common things that is needed in SQL Server is performing a restore of a database. It's also one of the most important things that needs to take place. So why isn't this a simpler process? Steve Jones wonders why we can't make this a simpler process.  Read more...

One of the very common things that is needed in SQL Server is performing a restore of a database. It's also one of the most important things that needs to take place. So why isn't this a simpler process? Steve Jones wonders why we can't make this a simpler process.  Read more...