Post reply

Backup the Database on multiple location at time using SQL 2000.

  • September 6, 2011 at 3:07 pm

    #247422

    Can we Backup the Database on multiple location at time using SQL 2000???

    I know SQL 2005 and later version has this functionality but by chance is there any way in SQL 2000??

    Thanks in advance for your help.

  • September 6, 2011 at 4:01 pm

    #1377719

    Do you mean to backup the database to multiple files?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • September 6, 2011 at 5:04 pm

    #1377748

    From SQL Server 2008 Books Online:

    "BACKUP (Transact-SQL)

    ...

    MIRROR TO <backup_device> [ ,...n ]

    Specifies a set of one or more backup devices that will mirror the backups devices specified in the TO clause. The MIRROR TO clause must be specify the same type and number of the backup devices as the TO clause. The maximum number of MIRROR TO clauses is three.

    This option is available only in SQL Server 2005 Enterprise Edition and later versions...."

  • September 6, 2011 at 5:05 pm

    #1377749

    I don't mean multiple file. I mean multiple location like we have functionality in SQL 2005 and later version called mirror backup.

  • September 6, 2011 at 5:07 pm

    #1377750

    Jinu43 (9/6/2011)

    I don't mean multiple file. I mean multiple location like we have functionality in SQL 2005 and later version called mirror backup.

    Nope - see note from Michael.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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