SQL Database Backup

desiree54ct · #1 (**permalink**) 11-03-03, 15:15

My largest database is 13gb and it takes 6 minutes to create a SQL backup. The database is expected to grow to 350GB can I extrapolate that to 161 minutes for the 350GB? Is there a formula for computing backup run time?

omiossec · #2 (**permalink**) 11-06-03, 15:58

There are many way to do that

First you can try to use --quick option with mysqldump

use mysqlhotcopy perl script

Use a slave mysql server to backup the db with replication

desiree54ct · #3 (**permalink**) 11-06-03, 16:46

Olivier,

Thanks for the response. I'm new to SQL Server and not familiar with MYSQLDUMP. I looked on Technet but the only reference was to migration. What is it, is it available with SQL Server 2000 and any refresnce source you may know of?

Desiree

aus · #4 (**permalink**) 11-07-03, 00:55

Sorry Desiree, this is a forum for MySQL, not SQL Server. You might want to use the SQL Server forum instead.

Quote:

Originally posted by desiree54ct
Olivier,

Thanks for the response. I'm new to SQL Server and not familiar with MYSQLDUMP. I looked on Technet but the only reference was to migration. What is it, is it available with SQL Server 2000 and any refresnce source you may know of?

Desiree

Internet Services

Web Development

Digital Marketing

Consumer Tech