Error in in sysft_Name while restoring database I have a .bak file which gives the following error while restoring:


  System.data.sqlclient.sqlerror:The path 'E:' has invalid attributes. It needs to be a directory. It must not be hidden, read-only, or on a removable drive.




But I verified that the directory is not read only. Anyone know how to restore the three files being restored ( .mdf,.ldf, and sysft)?

The script i had used for restoring database has been given below.

RESTORE DATABASE [new] FROM  DISK = N'E:\a\L11.bak' WITH  FILE = 1,  MOVE N'itest' TO N'E:\a\3.mdf',  MOVE N'itest_log' TO N'E:\a\4.ldf',  MOVE N'sysft_test' TO N'E:\a',  NORECOVERY,  NOUNLOAD,  REPLACE,  STATS = 10
GO
I think you need a "\" at the end of the path.

RESTORE DATABASE [new] FROM DISK = N'E:\a\L11.bak' WITH FILE = 1, MOVE N'itest' TO N'E:\a\3.mdf', MOVE N'itest_log' TO N'E:\a\4.ldf', MOVE N'sysft_test' TO N'E:\a\', NORECOVERY, NOUNLOAD, REPLACE, STATS = 10 
GO