April 12, 2011 at 10:32 am
Hi,
I am trying to do a restore from a SQL 2005 64-bit server to another SQL 2005 64-bit server and I'm getting the error "The path 'F:' has invalid attributes. It needs to be a directory. It must be hidden, read-only, or on a removable drive. (Microsoft.SqlServer.Smo). I only get this error when I try and restore to any other drives other than the C:\ drive on this server. It restores successfully to the C:\ drive with no error. The posts that I read up on for this error stated to make sure Full Text Search was installed on both servers (which it is) and to try and do the restore using TSQL instead of through the Management Studio (which I did)...but I still get the error. I spoke to our sysadmin to see what the difference may be with these other drives and here is what her response was:
"they've always been local drives
the VM's just used to live on there
always been a physical drive
in hyper-v it just saves the vm file on that drive
the ONLY difference is that the drives other than C are NOT RAIDED
they are stand-alone drives
C is mirrored
D E and F are NOT
that's the only diff
so there USED to be a Hyper-V machine on that drive - i've since formatted it"
I've never encountered this error before when trying to do a restore so if anyone could shed some light on this I would greatly appreciate it. 😀
Thanks,
Isabelle
Thanks!
Bea Isabelle
April 12, 2011 at 10:43 am
Hi,
with which account the sql server service is running? Has this user permissions to read "F:"? Try to open a cmd as the account user with
runas /noprofile /user:DOMAIN\USERNAME cmd
type in the user password and try to read a file from "F:".
Greets
Patrick Fiedler
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
April 12, 2011 at 11:19 am
Hi Patrick
Our sysadmin was able to successfully run the command you provided to the F:\ drive and create and save a text file using the domain account that is runninng the SQL service on the server. I went ahead and tried to run my restore again and still get the error:
Msg 9953, Level 16, State 1, Line 1
The path 'F:' has invalid attributes. It needs to be a directory. It must not be hidden, read-only, or on a removable drive.
Msg 3156, Level 16, State 50, Line 1
File 'sysft_ftcat_documentindex_d2d7c79aa5884ec88ed0da15f3b1160f' cannot be restored to 'F:\SQL_LOGS'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 1
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Thanks,
Isabelle
Thanks!
Bea Isabelle
April 12, 2011 at 4:07 pm
Have you already verified the restore paths of each file whose are listed on the options view of the management studio restore dialog? Perhaps there is a fault. Or try to get the header informations of the backup with RESTORE HEADERONLY.
Patrick Fiedler
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply