error in sysft_Name while restoring database.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

error in sysft_Name while restoring database.

Author

Topic

ammuhere
Starting Member

8 Posts

Posted - 2011-10-05 : 11:05:24

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 the directory is not read only.Any one knows how to restore when three files being restored .mdf,.ldf, and sysft.?
Please help me.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-10-05 : 11:54:13

What type of drive is E?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

ammuhere
Starting Member

8 Posts

Posted - 2011-10-05 : 12:15:53

steve_r18
Yak Posting Veteran

59 Posts

Posted - 2011-10-05 : 12:16:41

Is this by chance the CD drive? Or not local to the restoring machine? (UNC path would otherwise be required)If the e: drive from the restore point was the actual path on the backed-up database's server then you might have to use the WITH MOVE. This would be that the full-text catalog in the backup references that location or another that doesn't exist and you can then specify the location to restore to.

Steve

steve_r18
Yak Posting Veteran

59 Posts

Posted - 2011-10-05 : 12:18:24

quote:
Originally posted by ammuhere

We can't see this image for some reason...

Steve

ammuhere
Starting Member

8 Posts

Posted - 2011-10-05 : 12:20:04

ammuhere
Starting Member

8 Posts

Posted - 2011-10-05 : 12:21:09

Please refer this image

[url]http://postimage.org/image/2oowmjbpg/[/url]

ammuhere
Starting Member

8 Posts

Posted - 2011-10-05 : 12:23:15

This is the script i had used for restoring.
Also E: is not CD or remote drive.

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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-10-05 : 12:31:38

Are you able to restore the database without the fulltext file? Here's some info: http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/ca94d490d60839d0/03399ef906f6df22

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources