sql server - Can not able to take back up get error Msg 3201, Level 16, State 1, Line 1 -
i practicing create procedure take of data base except system database using dynamic sql
procedure compile when run below error 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 incorrect.). msg 3013, level 16, state 1, line 1 backup database terminating abnormally.
i have change default database path taking reference of this
here database setting snap
please suggest me way overcome problem..
a file name :
invalid, change them ;
.
@sql = '.....' + replace(@backuppath, ':', ';') + '....'
Comments
Post a Comment