Post reply

Backup Devices

  • December 19, 2008 at 11:39 am

    #125291

    How do I backup a database to 4 devices, on 2 different disks as there is not enough space on a single drive to create a single full backuo file. I created four devices two each on two separate disks and gave to command as

    Use master

    go

    BACKUP DATABASE [DCPPQTR] TO [DSBK1], [DSBK2], [DSBK3], [DSBK4] WITH INIT , NOUNLOAD , NAME = N'WesternSouthern backup', NOSKIP , STATS = 10, NOFORMAT

    go

    This is a SQL 7 server and the version is 1063.

    When the job is run, it is backing up to one disk completely and the job fails as it is not backing up to all four devices. Looks like it is creating a single backup file..any suggestions?

    Thanks in advance!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

  • December 19, 2008 at 2:56 pm

    #915659

    Were striped backups supported in v7?

    I've never used devices for this. I'd use disk files only, not devices.

  • December 19, 2008 at 5:30 pm

    #915686

    looks like sql 7 doesn't support device backups..i tried time and again but its copying only to a single file. I believe i ll have to have a dedicated disk with the space required for this backup

    Its about time we upgrade this server..is it possible to go to SQL 2008 from SQL 7?

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

  • December 22, 2008 at 12:05 pm

    #916302

    The_SQL_DBA (12/19/2008)

    looks like sql 7 doesn't support device backups..i tried time and again but its copying only to a single file. I believe i ll have to have a dedicated disk with the space required for this backup

    Its about time we upgrade this server..is it possible to go to SQL 2008 from SQL 7?

    Thanks!!

    I don't think so, general rule is 2 versions back (so 2000/2005 can upgrade to 2008, 7.0/2000 can upgrade to 2005)

    There are currently 2 versions of SQL Server Upgrade Assistant: the SSUA 2005 version supports upgrades from both SQL Server 7.0 and 2000 to 2008 and the SSUA 2008 version supports upgrades from SQL Server 2000 and 2005 to 2008.

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply