Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
honey_191
Starting Member
49 Posts |
 Posted - 2008-02-01 : 00:18:36
|
| Hi, I need to write a stored procedure to take the backup of a particular database.The backup file name must be included with the date and time(ex: work_fb_01312008_21:11.bak).I got some errors at the time of executionMsg 3201, Level 16, State 1, Procedure fbackup, Line 11Cannot open backup device 'D:\backup\Work_fb_20080201_00:10:35:090.bak'. Operating system error 123(The filename, directory name, or volume label syntax is incorrect.).Msg 3013, Level 16, State 1, Procedure fbackup, Line 11BACKUP DATABASE is terminating abnormally. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-02-01 : 03:35:54
|
This is a OS constraint.You can't create filename with colon ':' in it. Remove it from the backup file name.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
writing sp for a backup