Database name with a space char in it
deweigend
Posts: 20
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"
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
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8