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
