[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

why cannot backup sql server on the desktop or c drive

Hi guys

just a simple question?
i was trying to backup my database and if i changed the default location it did not allowed me to back up.

any specific reason?

just want to learn why.
thanks
0
titorober23
Asked:
titorober23
1 Solution
 
mozculluCommented:
this is due to sql service accounts not having necessary rights on this new location.
0
 
Ramesh Babu VavillaCommented:
this is the new feature of SQL Server 2008. it  is a security related advantage, other then sql server and admin user, no other can access the default path of the SQL Server.

you can change the default folldet by right click on the SQL server properties ->facelts. just check the screenshot


change the backup directory to your desired location

temp.JPG
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now