what characters not allowed in backup names?

• aozm

  SSC Journeyman

  Points: 89

  More actions

  October 5, 2005 at 1:21 am

  #165800

  I was searching for a list of characters that are not allowed in backup names?  For example, I don't think "\" or "/" are allowed because SQL probably thinks those are new directories.  Are there are other characters not allowed? 

  I am testing a third party program to make backups, and there is an option for splitting up the "parts" of the backup name - i.e., you can have database name, time, date...and those can be split up by a "-".   But if you try to split them by / or \, an error is given.

  Instead of trying each character on the keyboard individually (!, @, #, etc...)  to see if I get an error, I was wondering if there is a known list of characters not allowed...

  Thanks in advance for any help!

   

• philcart

  SSC-Forever

  Points: 47797

  More actions

  October 5, 2005 at 2:10 am

  #595078

  You can check the list here http://www.file-ext.com/character.html

  Whether you'd use them or not is another matter. I'd stick with the underscore character split up the parts,

  EG: master_db_20051005_1750.bak

   

  --------------------
  Colt 45 - the original point and click interface