Time reduction methods for backup on SQL Server

Asked By tracyann09 0 points N/A Posted on - 07/14/2011

Hello,

I'm Tracy Ann, I would like to know, is there any method to reduce the time taken for Backups on SQL Server. I have tried using few software to reduce the time, some work effectively but not for all type of files. Can you let me know if there is any way the backup time can be reduced?

• Status: Open
• Question Views: 1019
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Patrick03 0 points N/A #82551

Time reduction methods for backup on SQL Server

Hello ,

There are several methods to shorten the backup time in SQL server.

1. One way to reduce backups is to use back up data compression. This can be easily applied via a third party software or the native option available in SQL Server Enterprise. The three basic back up methods offered in SQL are:

• Full
• Differential
• Transaction

2. Quest’s Lite speed, redgate are common software used for this purpose and visit link for more information.

3. Another way to shorten the back up time is to back up to tape or hard disk. It’s not recommended to back up the database to the same disk used to store database and log file. This can affect the recoverability if the disk fails.

Please refer to Details.

About Patrick03

Questions
0

Answers
4

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 07/14/2011
• Question Category: MySQL Server