Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

Second SQL Instance can only see the c:\ drive

I just installed a second instance of SQL 2005 and am trying to restore a database, redirecting the data and log files to places other than the c:\ drive. The second instance only seems to be able to see the c drive though and when I manually type in the location I want to redirect the data and log files to I get an Operating System error #5.

Has anyone encountered something like this? If so, how did you enable the second sql instance to see other drives? The account that is running sql does have access to the other drives.
0
AADAC_ITS
Asked:
AADAC_ITS
1 Solution
 
chapmandewCommented:
Are you on a cluster?

Have you tried using the UNC path instead?  

\\servername\d$\logfile.ldf
0
 
indianguru2Commented:
Is it a Network Drive or an External Drive?

In both cases it won't show ... Copy you db backup to C Drive and Restore.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now