I am practicing to create procedure which take back up of all data base except system database using
Dynamic SQL my procedure compile successfully but when i run it i get below error for each data base
Msg 3201, Level 16, State 1, Line 1 Cannot open backup device 'F:\DHAVAL_BACKUP_DEMO\itmusket_StudentApp_2015_05_31_10:27:07.BAK'. Operating system error 123(The filename, directory name, or volume label syntax is incorrect.). Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally.
I have also change my default database back up path by taking reference of this
here is my database setting snap
please suggest me way to overcome this problem..