Post reply

Unable to backup or restore from desired drive in SQL 2005

  • November 8, 2006 at 9:09 am

    #193006

    Does anyone know why I would only be able to see 1 drive out of the 4 on the SAN from within Management Studio?

    I am on Windows 2003 and SQL 2005 sp1 installed on a cluster.  My sysadmin set up 4 drives (Sata, R:Backup, L:Logs, T:Temp) and claims I am using a domain account with all the privileges I need to be able to see these drives.  However, when I log in as sa and try to create a backup I can only choose the S drive.  Oddly, I can type in the R drive and it will write to it but I am unable to see it.  When I try to restore from the R drive I get the error: 

    Could not resolve specified location.  Either the location does not exist, or current login does not have access to it.

    Any thoughts on this would be greatly appreciated.  Thanks in advance!

  • November 8, 2006 at 9:09 pm

    #670757

    You'll need to have the other drives be dependecies for SQL Server. You can do this in cluster admin.  Select the SQL Server service go to properties, dependencies and add the drives.

    Restart the services and the other drives should be available.


    Victor Chong

  • November 10, 2006 at 9:51 am

    #671134

    That worked great!  Thanks!

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

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