How can we help you today? How can we help you today?

Backing up compressed databases

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?
sgiordano
0

Comments

1 comment

Sort by
  • petey
    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?
    petey
    0

Add comment

Please sign in to leave a comment.