Error-Backup on network drive

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » Error-Backup on network drive

Error-Backup on network drive

Rate Topic

Display Mode

Topic Options

Author

Message

pdiwadkar

Posted Wednesday, May 21, 2008 3:53 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 28, 2008 10:18 AM
Points: 3, Visits: 12

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

Post #504315

tosscrosby

Posted Wednesday, May 21, 2008 1:38 PM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 7:31 AM
Points: 2,832, Visits: 5,316

The infamous cross-post!! Angry

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

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

Post #504805

« Prev Topic | Next Topic »

Permissions