I recently have a backup compression issue with SQL 2017. The TFS is database is running in our SQL2017 standard RTM version. When I started the backup it shows 89 GB total in the backup folder. Once the backup completed 100% it shows 261 GB size, which is exactly size of the database.
Please let me know is there any know issue 's related to compression of database 's in SQL 2017 Standard RTM.
All the suggestion 's appreciated.
Thank You.
Hi,
Can you provide the full backup statement?
BACKUP DATABASE [Tfs_DefaultCollection] TO DISK = N'H:\SQL\Backup\UserDB\Full\Tfs_DefaultCollection\Tfs_DefaultCollection_backup_2018_10_02_122504_9417146.bak'
WITH MAXTRANSFERSIZE = 262144, NOFORMAT, NOINIT, NAME = N'Tfs_DefaultCollection_backup_2018_10_02_122504_9417146', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10
I see no obvious problems with the script.
We'e not using 2017 yet, so I cant compare it with statistics from earlier SQL Server versions.
Have you found a solution?
No..