Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Location
    CT
    Posts
    5

    Unanswered: SQL Database Backup

    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?

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    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
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Sep 2003
    Location
    CT
    Posts
    5
    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

  4. #4
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137
    Sorry Desiree, this is a forum for MySQL, not SQL Server. You might want to use the SQL Server forum instead.

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •