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:.

Answered question