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.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|||Thanks for the fast reply. The square brackets did the trick.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment