SQL Server Management Studio (SSMS) – Unable to detect Tape Drive

Today I was walking a customer through SQL Server database backup on tape and realized that I’m unable to view the tape drive from SQL Server Management Studio. At this time I took a pause to check the if all is well with the Tape Drive. Here’s tape drive config: •    Device – IMB Ultirum-TD3…

0

How to identify weather a Database Backup Set was compressed using WITH COMPRESSION

This is in continuation with my first blog “SQL Server 2008 Backup Compression”. I received this query from one of the reader about “How to determine, if a Database Backup set was compressed using WITH COMPRESSION”. A simple way to identify this to use RESTORE HEADERONLY. RESTORE HEADERONLY command can be used to fetch all…

1

SQL Server 2008 Backup Compression

I’m still in process to make myself familiar with latest SQL Server release i.e. SQL Server 2008. To begin with, I concerted on new features/enhancements related to database administration and came across with this interesting new feature – SQL Server 2008 Backup Compression. In the past few years, there has been a tremendous growth in…

4