What are the challenges you face when working across database platforms? Take the survey
Options

Database name with a space char in it

deweigenddeweigend Posts: 20
edited September 23, 2005 2:31PM in SQL Backup Previous Versions
Hello,

I received a syntax error with this command when typing to backup a database that has an embedded space character in it. This is the only database that is named this way and this command has worked perfectly for all databases that do not have an embedded space. What can I do to fix this?

-SQL "BACKUP DATABASE [Event Logs] TO DISK = [\\athena-dellsnap\SQLBackups\dmsoprsql\Event Logs_a.sqb] WITH COMPRESSION = 2, LOGTO = [\\athena-dellsnap\SQLBackups\dmsoprsql\Event Logs_a.sqb.log.txt], password = [asdfGhjkl91], init"

Comments

Sign In or Register to comment.