更新时间:2023-01-23 10:15:47
hi,
试试这个代码....
DECLARE @SqlString VARCHAR(1000)
SELECT @SqlString =''BACKUP DATABASE eUnderwrite TO DISK =''''path''+ REPLACE(CONVERT(VARCHAR(15),GETDATE(),106),'''',''_'' )++''_''+ REPLACE(CONVERT(VARCHAR(25),GETDATE(),108),'':'',''_'')+''。bak''''WITH INIT''
PRINT @SqlString
EXEC(@SqlString)
Try this code....
DECLARE @SqlString VARCHAR(1000)
SELECT @SqlString = ''BACKUP DATABASE eUnderwrite TO DISK = ''''path''+ REPLACE(CONVERT(VARCHAR(15),GETDATE(),106),'' '',''_'')++''_''+REPLACE(CONVERT(VARCHAR(25),GETDATE(),108),'':'',''_'')+''.bak'''' WITH INIT''
PRINT @SqlString
EXEC (@SqlString)
您可以尝试使用SqlCmd实用程序。代码如
You can try SqlCmd utility. Code like
CALL sqlcmd -w 125 -S %Server% -d %Database% -U%uid% -P%pwd% -l30 -b -I -i "dbscript.sql"
详细信息你可以查看 SqlCmd实用程序