Post reply

Cannot see new Network Drive

  • August 1, 2007 at 8:38 am

    #69040

    Hi All,

    We have a SQL Server 2000 sp4 database server running one of our sub companies financial systems.  A 1TB network drive (ntfs) has been added by our network engineers to the server to perform temp local backups, this can be seen as drive h: through windows explorer.   However when I try and backup to the drive I get a 'cannot open backup device error.'

    Do I need to restart SQL Server?

     

    Kind Regards.

  • August 1, 2007 at 9:29 am

    #723926

    Hi deucellion,

    If you still have xp_cmdshell on your SQL Server, try running the following:

    exec master..xp_cmdshell 'dir h:\' --If this works, try the next line:

    exec master..xp_cmdshell 'echo "test" > h:\test.txt' --look for this file on h:\

    If either of these fail, then SQL doesn't have permissions to access this drive.  Let us know what you find!

     

    Thanks,

    Eric

  • August 1, 2007 at 9:35 am

    #723930

    Hi Strommy,

    Thanks for the help.  It seems the the SQL Server is running under the local system account which can't seen nw resources.  So hopefully just changing this will resolve the prob..

     

    Cheers,

    D.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply