question

erik_40984 avatar image
erik_40984 asked

Back up DB with dash in DBname by maintenanceplan

Running maintenance plans in SQL 2008 R2 fails on DB's with dashes or long names. Is it possible to backup such databases in a job created by maintenanceplan?
sql-server-2008-r2backupmaintenance-plansdatabase-name
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Tim avatar image
Tim answered
I have always used custom scripts such as [Ola Hallengren's]( http://ola.hallengren.com/), I am not sure you can modify the maintenance plan to include brackets [] to enclose the db names with dashes in the name.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I'll have to look into Hallengren's during the weekend :-)
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.