Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007
    Posts
    5

    Unanswered: Backup Transaction Log

    What is the proper way to backup a transaction log for a database whose name contains a space. (I.E. DBname = Database Name). I am trying to execute a command, but it does not like the space in the database name. I have also tried wrapping the name in single quotes and parethesis to no avail.

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by xdawg12
    What is the proper way to backup a transaction log for a database whose name contains a space. (I.E. DBname = Database Name). I am trying to execute a command, but it does not like the space in the database name. I have also tried wrapping the name in single quotes and parethesis to no avail.
    Parenthesis ()? Or square brackets []? Try the square brackets.

    Also (not trying to be flippant), try to avoid spaces in db names.

    Regards,

    hmscott
    Have you hugged your backup today?

  3. #3
    Join Date
    May 2007
    Posts
    5
    Thanks for the fast reply. The square brackets did the trick.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •