bibi92
asked on
error on t-sql script
Hello,
I try to build a backup command but the default backup directory is specified :
DECLARE @FILE VARCHAR(65)
DECLARE @DUMPFILE VARCHAR(150)
SELECT CONVERT(VARCHAR(10),GETDAT E(),112)
SELECT CONVERT(VARCHAR,GETDATE(), 108)
SELECT REPLACE(CONVERT(VARCHAR,GE TDATE(),10 8),':','')
SET @FILE = CONVERT(VARCHAR(10),GETDAT E(),112) + '_' + REPLACE(CONVERT(VARCHAR,GE TDATE(),10 8),':','')
SELECT @FILE
SET @DUMPFILE = '''' + 'd:\backup' + @FILE + '.bak' + ''''
SELECT @DUMPFILE
BACKUP database test
to disk=@DUMPFILE
with compression, copy_only
Msg 3201, Level 16, State 1, Line 15
Cannot open backup device 'E:\MSSQLSQL01\BACKUP\'d:\ backup2016 0824_18042 4.bak''. Operating system error 123(failed to retrieve text for this error. Reason: 15105).
Msg 3013, Level 16, State 1, Line 15
BACKUP DATABASE is terminating abnormally.
Why?
Thanks
Regards
I try to build a backup command but the default backup directory is specified :
DECLARE @FILE VARCHAR(65)
DECLARE @DUMPFILE VARCHAR(150)
SELECT CONVERT(VARCHAR(10),GETDATE(),112)
SELECT CONVERT(VARCHAR,GETDATE(),108)
SELECT REPLACE(CONVERT(VARCHAR,GETDATE(),108),':','')
SET @FILE = CONVERT(VARCHAR(10),GETDATE(),112) + '_' + REPLACE(CONVERT(VARCHAR,GETDATE(),108),':','')
SELECT @FILE
SET @DUMPFILE = '''' + 'd:\backup' + @FILE + '.bak' + ''''
SELECT @DUMPFILE
BACKUP database model
to disk=@DUMPFILE
with compression, copy_only
DECLARE @FILE VARCHAR(65)
DECLARE @DUMPFILE VARCHAR(150)
SELECT CONVERT(VARCHAR(10),GETDAT
SELECT CONVERT(VARCHAR,GETDATE(),
SELECT REPLACE(CONVERT(VARCHAR,GE
SET @FILE = CONVERT(VARCHAR(10),GETDAT
SELECT @FILE
SET @DUMPFILE = '''' + 'd:\backup' + @FILE + '.bak' + ''''
SELECT @DUMPFILE
BACKUP database test
to disk=@DUMPFILE
with compression, copy_only
Msg 3201, Level 16, State 1, Line 15
Cannot open backup device 'E:\MSSQLSQL01\BACKUP\'d:\
Msg 3013, Level 16, State 1, Line 15
BACKUP DATABASE is terminating abnormally.
Why?
Thanks
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
Please could you try removing two apostrophes from the beginning and end. e.g.
SET @DUMPFILE = '' + 'd:\backup' + @FILE + '.bak' + ''
Thanks,
Helen