SQLDMO backup error

• anitae

  Old Hand

  Points: 375

  More actions

  October 31, 2002 at 5:10 pm

  #64204

  I'm using Andy's SQLDMO backup example to backup my databases on the server.

  It works fine when I backup to C:\Backup. But when I try to backup to a directory

  that contains a space in the name, like "C:\Backup\Database Backups" I get an error.

  Cannot open backup device..... device error or device off line.

  How can I get it to work in cases where there might be a space in one of the directory names?

  Thanks.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  October 31, 2002 at 5:22 pm

  #440008

  Wrap it in brackets, like this:

  "[C:\Backup\Database Backups]"

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn