Subject | Backup Time |
---|---|
Author | Louis Werth |
Post date | 2007-01-22T19:45:11Z |
Hi
I recently began with a database cleanup procedure, I deleted about 4Gig of
data out of a 9gig database.
Before the script, it took about 1hour to backup database and 1.5hours to
restore.
Cleanup Script takes about 14min to complete.
Backup after script takes 12hours to backup and 1.5 to restore.
What can I do to speed this up? I cannot afford that my client go down for
13Hours +
Any help would be appreciated.
Software:
=======
WinXP Pro
Firebird 1.53(Superserver)
Database Page Size=8192
Sweep Interval = 0
Hardware:
=======
2 Gig Ram
2x 160Gig Serial ATA2 HDD
3GHz Core 2 Duo Intel Processor.
Regards
Louis
[Non-text portions of this message have been removed]
I recently began with a database cleanup procedure, I deleted about 4Gig of
data out of a 9gig database.
Before the script, it took about 1hour to backup database and 1.5hours to
restore.
Cleanup Script takes about 14min to complete.
Backup after script takes 12hours to backup and 1.5 to restore.
What can I do to speed this up? I cannot afford that my client go down for
13Hours +
Any help would be appreciated.
Software:
=======
WinXP Pro
Firebird 1.53(Superserver)
Database Page Size=8192
Sweep Interval = 0
Hardware:
=======
2 Gig Ram
2x 160Gig Serial ATA2 HDD
3GHz Core 2 Duo Intel Processor.
Regards
Louis
[Non-text portions of this message have been removed]