BACKUP DATABASE error

Got a problem you cannot solve? Try here.
mdavtec
Posts: 27
Joined: Wed Jan 20, 2016 2:59 pm

BACKUP DATABASE error

Postby mdavtec » Tue Mar 10, 2020 5:07 pm

Hard coded path works fine:
BACKUP DATABASE [MYDB] TO DISK = 'C:\ProgramData\SQLServerBackup_HC.bak'

Using variable in path doesn't work:
Set Variable PROGRAMDATAFOLDER to C:\ProgramData
BACKUP DATABASE [MYDB] TO DISK = '$PROGRAMDATAFOLDER$\SQLServerBackup_VAR.bak'

It tries to append the DISK path to C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MYINST\MSSQL\Backup
Error in the event log:
BackupDiskFile::CreateMedia: Backup device 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MYINST\MSSQL\Backup\ C:\ProgramData\SQLServerBackup_VAR.bak' failed to create. Operating system error 123(The filename, directory name, or volume label syntax is incorrect.).

Thanks in advance.
ExchA

mdavtec
Posts: 27
Joined: Wed Jan 20, 2016 2:59 pm

Re: BACKUP DATABASE error

Postby mdavtec » Wed Mar 11, 2020 9:47 am

Not sure what I was doing wrong, but it is now working. Please ignore my question.
ExchA


Return to “Technical Support”

Who is online

Users browsing this forum: No registered users and 41 guests