Error-Backup on network drive

• pdiwadkar

  SSC Veteran

  Points: 237

  More actions

  May 21, 2008 at 3:53 am

  #123923

  Hi,

  I am trying to backup database(full) on a network drive.Network drive is accessible from windows explorer.I created one user,backup_user(with Administrator permission) in Windows Account.The same user I added in SQL server-Login and made him sysadmin.

  I created Maintenance Plan,SQL Job.When I run the job, I get the following error:

  Failed:(-1073548784) Executing the query "EXECUTE master.dbo.xp_create_subdir N'S:\\HR_Server\\Data\\hrdb'

  The system cannot find the path specified.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

  Command:EXECUTE master.dbo.xp_create_subdir N''S:\HR_Server\Data\hrdb''

  The above path S:\.. exist on network drive.Though error includes path with "S:\\..", in actual I have given "S:\..." While creating job, I checked "Create sub directory option" too.

  Thanks

  PD

• tosscrosby

  SSCoach

  Points: 18045

  More actions

  May 21, 2008 at 1:38 pm

  #818842

  The infamous cross-post!!:angry:

  http://www.sqlservercentral.com/Forums/Topic504585-357-1.aspx

  -- You can't be late until you show up.