I was running into a disk space problem that was only revealed when I tried to restore a production database to the test environment that was several GBs bigger.
I updated the DB’s files to point to a new drive on the server, moved the files and restarted the service. All good.
Then, as I attempted to restore the database, I kept getting files pace errors.
The problem? I had forgot to alter the restoration file location and SQL Management Studio was trying to use the original file path.
Here’s where you make the change:
When you go to Tasks –> Restore –> Database, select the Options page and change the target paths for your database files.