No announcements
Found 95928 threads
-
0 Votes
Backup without compression backups wth compression
The backups weren't being compressed.Answered | 3 Replies | 976 Views | Created by anaylor01 - Saturday, August 27, 2016 11:16 PM | Last reply by Shanky_621 - Sunday, August 28, 2016 5:44 AM -
1 Votes
Backup Compression
Hi there, when you take backup SQL server uses the default setting of your server.Answered | 3 Replies | 2219 Views | Created by Evne Maximoy - Tuesday, January 8, 2013 6:04 PM | Last reply by Kumar muppa - Wednesday, January 9, 2013 5:12 AM -
2 Votes
Compression Backup
please could anyone provide me the impacts of compressed backup.Answered | 7 Replies | 846 Views | Created by venusura - Tuesday, September 8, 2015 8:58 AM | Last reply by venusura - Tuesday, September 8, 2015 9:30 AM -
2 Votes
Compressed SQL Server Backups
I restored two of the Compressed Prod DB backup files on our Test instance and it appears to be transparent as to compression.Answered | 4 Replies | 2254 Views | Created by Mysetdancer - Tuesday, November 5, 2013 4:44 PM | Last reply by Rama Udaya - Tuesday, November 5, 2013 5:52 PM -
0 Votes
Backup Compression : How it works?
I'm very curious to know how exactly sql compress the backup.Answered | 9 Replies | 1959 Views | Created by Devender Bijania - Wednesday, December 31, 2014 9:10 AM | Last reply by Mr. Monkeyboy - Saturday, January 3, 2015 7:23 AM -
0 Votes
database backup compression
In SQL 2005....SQL Native Backup would not give you any compression.Answered | 3 Replies | 2466 Views | Created by sakurai_db - Wednesday, September 26, 2012 4:14 AM | Last reply by SQLHarry - Wednesday, September 26, 2012 2:07 PM -
0 Votes
default backup compression
If you enable compression at the server level then compression will be applied by default to all the databases.Answered | 5 Replies | 867 Views | Created by mastanvali shaik - Monday, August 18, 2014 6:29 AM | Last reply by Prashanth Jayaram - Monday, August 18, 2014 1:25 PM -
0 Votes
SQL Server backup Compression
First sql server will allocate the space for backup and then will it compress ?Answered | 3 Replies | 1502 Views | Created by Vinodh Selvaraj - Monday, January 5, 2015 11:41 AM | Last reply by Edvaldo C. Castro - Monday, January 12, 2015 1:42 PM -
2 Votes
TDE and Backup Compression
The amount of compression depends on the type of data in the backup and whether encryption is enabled on the database or not.Answered | 5 Replies | 935 Views | Created by PhannyDAU - Tuesday, May 22, 2018 8:14 AM | Last reply by S_NO - Wednesday, May 30, 2018 5:02 PM -
0 Votes
Compression backup feature
Dear folks, if we have got this option enabled, could it affect to our third-party backup solution, Veeam?Answered | 4 Replies | 553 Views | Created by Enric Vives - Wednesday, August 24, 2016 3:18 PM | Last reply by S_NO - Wednesday, August 24, 2016 6:09 PM -
0 Votes
Database backup compression
The amount of CPU overhead is fairly small for compressed backups, and the benefit is less IO and less overall space used.Answered | 2 Replies | 4536 Views | Created by Asheesh pandey - Thursday, August 16, 2012 8:53 AM | Last reply by Asheesh pandey - Thursday, August 16, 2012 2:30 PM -
2 Votes
Compression of BACKUP of SQL Server 2005
In fact, Red Gate has two compression tools, SQL Backup and SQL Hyperbac.Answered | 4 Replies | 31597 Views | Created by Adil Kazmi - Tuesday, October 11, 2011 2:45 PM | Last reply by Grant Fritchey - Monday, October 17, 2011 1:45 PM -
0 Votes
Compressing backups without integrated tools
It implements database backup/restore directly to or from a compressed file(GZIP format), the performance is better than the native backup/restore, up to 180M/s.Answered | 6 Replies | 5962 Views | Created by CR8N - Wednesday, January 21, 2009 9:05 PM | Last reply by Ben.Hu - Friday, January 22, 2010 8:48 AM -
1 Votes
Restoring a Compressed Backup in SQL2012 Standard
Vishe, it will compress and uncompress the sane DB on a restore in Standard?Answered | 7 Replies | 1250 Views | Created by MaxShapiro - Friday, April 7, 2017 9:49 PM | Last reply by MaxShapiro - Saturday, April 8, 2017 4:48 PM -
1 Votes
SQL 2000 DB backup compress
Hello, You could backup to a compress Folder, but this will cause a really bad Performance.Answered | 4 Replies | 2360 Views | Created by winoa - Thursday, February 27, 2014 1:13 PM | Last reply by Olaf Helper - Thursday, February 27, 2014 5:54 PM -
1 Votes
Sql Server 2008 Backup Compression
Please tell me what is the difference between these three option: 1.Use the default server setting 2.Do not ...Answered | 3 Replies | 3304 Views | Created by VijayKSQL - Thursday, September 6, 2012 5:46 PM | Last reply by Andrew Bainbridge - Friday, September 7, 2012 3:15 PM -
0 Votes
SQL Server compressed backups on Tapes
The scenario you present does not involve backing to a tape but rather copying files from the file system to the tape media and in this case it does not matter if the sql backup file is ...Answered | 1 Replies | 4563 Views | Created by SQLGuy2012 - Wednesday, November 23, 2011 1:14 PM | Last reply by Yaniv Etrogi - Wednesday, November 23, 2011 10:43 PM -
0 Votes
How to compress DB backup file with sql query
I used a third party utility called 'SQLBackupMaster' to backup, compress and schedule database backup.Answered | 7 Replies | 15901 Views | Created by prdeepkumawat - Friday, August 1, 2014 1:51 PM | Last reply by prdeepkumawat - Thursday, August 14, 2014 9:54 AM -
0 Votes
Backup Compression SQL Server 2008 R2 Enterprise
In the above link you can notice the backup time taken for database backup wiht compression and with out compression.Answered | 2 Replies | 1005 Views | Created by Aleds - Wednesday, November 14, 2018 4:24 PM | Last reply by Kumar muppa - Wednesday, November 14, 2018 11:49 PM -
0 Votes
Problems faced when backup are directed to compressed folders.
I recommend that you put your backup file to a folders or driver without compression enabled.Answered | 2 Replies | 9726 Views | Created by yup. _ - Wednesday, March 31, 2010 8:10 AM | Last reply by Tom Li - MSFT - Friday, April 2, 2010 8:41 AM - Items 1 to 20 of 95928 Next ›
No announcements