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"