Copy Never Performed When Destination Name Contains Colon

Question

When backing up my database by executing the following command. The copy never begins (even after waiting over an hour). I am verifying that the copy never starts by checking percent_complete on sys.dm_database_copies.

CREATE DATABASE [mydb:backup] AS COPY OF [mydb]

I have tried a few variations and it appears the problem is the colon character in the destination database name. If I use underscores, hyphens or spaces, the copy is executed within minutes.

Since SQL Azure allows me to create a database with a colon in the name, it appears to be a bug that this prevents the copy from proceeding. At the very least, an exception should be returned instead of accepting the copy command.

Answer 1

Hi vanslyck,

Suggest you to submit a feedback to Microsoft for this issue. For submitting a feedback to Microsoft such issues, I would recommend to submit it to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback. This connect site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft Connect.

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Thanks, I was having trouble finding the right place to report the bug.

https://connect.microsoft.com/SQLServer/feedback/details/755326/database-copy-never-performed-when-destination-name-contains-a-colon