Transaction Log Backup Failure

• lnikodym

  Valued Member

  Points: 60

  More actions

  July 7, 2004 at 7:02 am

  #108868

  I've come across a problem that I've never had to deal with before.  Last week, a network administrator installed a software packaging application that created a database on our SQL 2000 server.  The database name was named Software Manager Database when it was created by default.

  I have a job that runs after our backups to truncate the transaction log and shrink the databases and am getting an error when trying to run a transaction log backup. 

  The command that's running is:

  BACKUP LOG Software Manager Database WITH TRUNCATE_ONLY

  The error message I receive is:

  Incorrect syntax near 'Manager'.

  I'm sure there's a very simple solution to this, but I've never had to deal with any databases that included spaces/multiple words in the database name. 

  Any help would be appreciated.

  Thanks

  --Lou

   

  
  
  

• lnikodym

  Valued Member

  Points: 60

  More actions

  July 7, 2004 at 7:11 am

  #513631

  I figured it out.  The database name had to be encapsulated in double quotes to run.  I was trying single quotes and parenthesis instead.

  The correct line of code was:

  BACKUP LOG "Software Manager Database"  WITH TRUNCATE_ONLY.

   

  --Lou