UNSOLVED

lzhu1

updated

15 years ago

L

lzhu1

24 Posts

0

2029

September 27th, 2011 07:00

back up sql server dbs to VTL on Data domain

Is it possible to use sql server native backup feature to backup database to VTL hosted on Data Domain?

thanks

long

  • dynamox

    11 Legend

    •

    20419 Posts

    •

    87439 Points

    1112

    0

    Posted September 27th, 2011 07:00

    without using a media changer ? You need something that will mount virtual tapes ..etc. Instead of all that hassle could you use regular CIFS shares on Data Domain as your target ?

  • dynamox

    11 Legend

    •

    20419 Posts

    •

    87439 Points

    1112

    0

    Posted September 27th, 2011 08:00

    is network connection the bottleneck ?

  • dynamox

    11 Legend

    •

    20419 Posts

    •

    87439 Points

    1112

    0

    Posted September 27th, 2011 08:00

    VTL adds complexity, cost. First you will need to purchase VTL license, second if you want to write to VTL directly from your hosts, you will need to use backup application that supports "LAN-Free" backups. I have not looked at ntbackup in years, maybe you could give that a try.

  • lzhu1

    24 Posts

    1112

    0

    Posted September 27th, 2011 08:00

    we are using sql native backup via regular CIFS backing up sql dbs to Data Domain right now without VTL in the picture. just not sure about using VTL on Data Domain.

  • lzhu1

    24 Posts

    1112

    0

    Posted September 27th, 2011 08:00

    VTL comes to the conversations as we seem to have pressure to finish all backups during the fixed window time.

  • dynamox

    11 Legend

    •

    20419 Posts

    •

    87439 Points

    1112

    0

    Posted September 28th, 2011 13:00

    CIFS is different from VTL. CIFS is a network share on DD , VTL is tape library emulation that can only be accessed via fiber channel network.

  • lzhu1

    24 Posts

    1112

    0

    Posted September 28th, 2011 13:00

    thanks. 3rd party backup tools will work. But I am thinking,  if we can set up CIFS from sql host to VTL on DD, then I should be able to just use sql native backup commands to backup dbs to there (VTL)?