SQL Server - Creating Folder in a Shared Folder and Backup Database in Network.

Asked By Vishwa I on 29-Aug-18 06:54 AM

Hi,

I am trying to write a script in SQL Server 2008 Express Edition for creating a folder in a network drive and then Backup database in that folder.

While trying to create the above folder a following error appears xp_create_subdir() returned error 161, 'The specified path is invalid.'

Please do suggest me how to do the same.