April 13, 2013 at 9:15 am
Hello,
I have question regarding backup SQL'05.
Please look ta my script :
sqlcmd -S srv_name -U sa -P pass -Q "BACKUP DATABASE Database_name TO DISK = 'D:\Backup\%date%_Database_name.bak' WITH NAME = 'Database_name_backup', FORMAT"
If i remove %Date% backup process will be completed successfully. But with %Date% I ahve folowing error:
Cannot open backup device 'D:\Backup\%date%_Database_name.bak' Date is repleaced by system time...
Please tell me what is wrong...
Thx for help
michal
April 13, 2013 at 4:41 pm
mjarosz (4/13/2013)
Hello,I have question regarding backup SQL'05.
Please look ta my script :
sqlcmd -S srv_name -U sa -P pass -Q "BACKUP DATABASE Database_name TO DISK = 'D:\Backup\%date%_Database_name.bak' WITH NAME = 'Database_name_backup', FORMAT"
If i remove %Date% backup process will be completed successfully. But with %Date% I ahve folowing error:
Cannot open backup device 'D:\Backup\%date%_Database_name.bak' Date is repleaced by system time...
Please tell me what is wrong...
Thx for help
michal
That is because SQL Server doesn't know what %date% is. It sees it as a string. If you are attempting to write your backups to a directory named with a date value (such as 20130413) you have put that in there by building the string needed for the backup command.
April 13, 2013 at 6:44 pm
If you are running this as an operating system command (dos), then try %date:/=_% instead of %date%, this will output dates with the "/" replaced by "_" making for a valid filename.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy