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:.
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:\users\appdata\solidcpuser\…. I would like to tell SolidCP where to place the temp backup file location other than the c: drive.
Correct that is the location that I want to change / configure solidCP not to use. Any ideas?
Hello,
Does the “SolidCP Server backup path:” not do what you need?
Regards,
Marco
Where is the setting: “SolidCP Server backup path:” located? I dont see that on the sql service server settings?
Do you have the latest SolidCP installed?
As in my mssql provider settings i have a section called “backup options”
one is SolidCP Server backup path: and the other is Network path or linux mount point:
(The last one you most likely do not have yet as it’s an option we made for remote mssql features which will be released in 1.4.7 on monday).
running 1.4.6. To confirm where are the settings you are referring to located? Is this in the portal under server service properties or in a dotnet .config file for the sql servers?
It’s in the portal –> configuration –> Servers –> servername –> mssql server properties atleast for me. (Do note mine been used to test the remote mssql / mysql features, but the backup location was a pre-existing property as far as i remember).