Restore of database 'Configurations_188.8.131.52' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)
------------------------------ ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: There is insufficient free space on disk volume 'E:\' to create the database. The database requires 22758293504 additional free bytes, while only 10663624704 bytes are available. (Microsoft.SqlServer.SmoExtended)
I am getting the above error when trying to restore a bak file I was given. It is not an option for the database to be shrunk before creating the bak.
I have 9.99GB free on E:\ and I have 59.7GB free on D:\
How can I change this to point to D:\ instead of E:\? and will changing the disk solve my problem? Thanks
EDIT: Solved my problem. In Restore Database -> File -> I changed the Log file folder path to D:\, then under Options I checked Override