Backing up Database to a Hidden Share

• C Schaefer

  SSC-Addicted

  Points: 415

  More actions

  March 25, 2005 at 4:56 pm

  #152371

  I am trying to backup a database to a hidden share using a maintenance plan.

  When I try to specify the directory to backup to (via UNC to another location on the network) the location as \\servername\myshare$, I get "The backup directory is invalid".  If I use \\servername\common (not hidden) it works fine, so the two servers are communicating.

  Is there a restriction that keeps me from using a hidden share as a destination for a backup?

  Thanks,

  Craig

  PS  this is SQL Server 2000 on a 2003 Server installation.

• Kishore-132325

  Hall of Fame

  Points: 3784

  More actions

  March 27, 2005 at 10:39 pm

  #549079

  Hidden shares should not make a difference. Try unhiding the share and taking a backup. If it works fine, then, unhide and take a backup.

  I have my SQL Server backups going to hidden shares and it works fine. You should be having the appropriate rights to take the backup.

  Hope this helps.

  --Kishore