Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-22 : 09:08:03
|
| Skinner writes "I'm in the process of installing an upgrade to a vendor's product we've had for years. They're asking us to backup a database to disk "with INIT, NAME, NOSKIP, STATS, NOFORMAT ". The backup directory lives on the same server that the database lives on. The first time we back up the database OR if we delete the backed up file before a subsequent backup, the process takes about 10-15 minutes. If we don't delete the backed up file before a subsequent backup, the process takes 3-4 hours. Curious if there's a reason for this. Obviously, the fix is to delete the backed up file, like I said just curious. Thanks" |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-04-22 : 11:19:57
|
| 3-4 hours seems pretty excessive, but you might want to look up each of the paramaters in BOL. Using the NOFORMAT with INIT, and NOSKIP are causing the backup to do a lot of checks and verifications on the pre-existing backup file before it actually overwrites it. This shouldn't take 3-4 hours, but it will slow down the backup time. If you want to overwrite the file everytime, then you're not keeping multiple backup sets in the file, and there's no reason for the NOSKIP and NOFORMAT commands. Maybe give it a try with just INIT, NAME, STATS.Jeff BanschbachConsultant, MCDBA |
 |
|
|
|
|
|
|
|
backup database to disk