Post reply

Backing up to network - SQL 6.5!

  • October 25, 2005 at 10:20 am

    #111165

    Is it technically possible to backup the database AND transaction logs to a network location (i.e. on a NAS server)? If so how please?

    (Currently we use the "DUMP TRANSACTION" command to backup the logs on the hour and .. the "DUMP DATABASE" command every night.)

    Thanks for your help.

  • October 25, 2005 at 11:45 am

    #599891

    Yes, you can create UNC based backup devices on SQL 6.5.

    Your friendly High-Tech Janitor... 🙂

  • October 25, 2005 at 12:03 pm

    #599900

    Excellent to know!

    The next question .... How please?

    thanks.

  • October 25, 2005 at 12:55 pm

    #599917

    Create a new dump device and specify your unc path as the location.

    I don't have a 6.5 handy anymore so I can't recall the specific syntax.  Lookup sp_add_dumpdevice or sp_adddumpdevice in Books Online.  You can find the exact syntax in BOL.

    Your friendly High-Tech Janitor... 🙂

  • October 26, 2005 at 11:31 am

    #600322

    Beware of failures and slow backup times. Since you are using a NAS instead of a SAN these may be bigger issues than you think. You may want to monitor the network pipe between your SQL Server and the 'shared' network pipe into the NAS should be monitored initially for performance bottlenecks.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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