I’m trying to create a script for a backup job in SQL Server Management Studio (SSMS). However, I face the error message Value cannot be null. Parameter name: urn
. The workflow up to that point is:
- Right-click on the database >
Tasks
>Back Up...
- Add a file name into the entry field of
Destination
- Choose
Script Action to Job
(Ctrl+Shift+M) - Go to
Steps
>New...
The solution to a similar problem seems to be already fulfilled. Please see the image: in my view, the environment values for TEMP
and TMP
are properly defined in the User variables
section. The directory 2
therein, which is necessary for SSMS, does exist. I have started SSMS as an administrator. The C:
drive has 150 GB space left.
Is there another point I’m missing?
Or is there something I misunderstood in the handling of the environment variables?
Some facts about the environment I’m working with:
- Microsoft SQL Server 2019
- SSMS v18.10
- Windows Server 2016 Standard, runs on a virtual machine