Backing up compressed databases

sgiordanosgiordano Posts: 2
edited May 23, 2011 8:56PM in SQL Backup Previous Versions
We are having trouble backing up databases which have been compressed in SQL Server 2008 R2. If we select a compression level in SQL Backup, the backup hangs. If no compression is selected, the backup is sucessful. Has anyone else had similar issues?
Susan
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    What version of the SQL Backup Agent are you running? Could you please run the following:
    DECLARE @version nvarchar(16) 
EXEC master..sqbutility 1030, @version OUTPUT 
SELECT @version
    and post the result?

    Also, while the compressed backup is running on the compressed database, try running the following in intervals of 5 seconds:
    EXEC master..sqbstatus 1
    Do the numbers increase?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.