Is there a way to change the location of where a SQL backup is initially generated? IE: instead of C: make it a specific folder on the D:. This question is not about where the users says download to browser or to a location in the hosting space. But the location on the SQL Server itself where the backup is first created. Currently this is causing some issues as we limit the C: space and when a user has a very large database there is sometimes no room for it on the C:.
Does any one know if there is a way to change this location?
Right click > Properties on the server in SSMS
Database Settings
Database default locations
Thanks for the note and i am aware of that option. This was about the temporary location that is used to create the database backup with SolidCP. Trying to call from memory something like c:usersappdatasolidcpuser.... I would like to tell SolidCP where to place the temp backup file location other than the c: drive.
C:UsersSCPServerAppDataLocalTemp
