x

Unable to restore from transaction log into a different server

I get the following error when I try to restore a transaction log backup after restoring the database with Restore with NORECOVERY onto a different server(SQL2005).

System.Data.SqlClient.SqlError: The path 'E:\SQL Server Install\MSSQL.2\MSSQL\FTData\FT_ESCore_Search_TitleSummaryCache275' has invalid attributes. It needs to be a directory. It must not be hidden, read-only, or on a removable drive. (Microsoft.SqlServer.Smo)

E drive does not exist on this server.
more ▼

asked Jul 09, 2010 at 05:12 AM in Default

mistp001 gravatar image

mistp001
3 2 2 2

What's your method of restoring? Parameters?
Jul 09, 2010 at 06:32 AM Magnus Ahlkvist
I am using Sql Management Studio on the actual server to restore. The backup file is from a different server. I managed to restore from the .bak file with the option of Restore with NORECOVERY. I then try to restore the transaction log with Restore with NORECOVERY option so I can restore subsequent transaction log.
Jul 12, 2010 at 03:54 AM mistp001
(comments are locked)
10|1200 characters needed characters left

5 answers: sort voted first

It appears that there is a Full Text catalog referenced in the restore.

Does the following path exist on the new server: E:\SQL Server\Install\MSSQL.2\MSSQL\FTData ?

If not, try and create that and copy the directory at the file-system level first.
more ▼

answered Jul 12, 2010 at 06:22 AM

Blackhawk-17 gravatar image

Blackhawk-17
11.9k 28 31 36

Unfortunatly, the E drive has been assigned to CDROM. Is there any other way ????????
Jul 12, 2010 at 06:44 AM mistp001
Use the WITH MOVE clause of your restore to set the FT Catalog to a valid location.
Jul 12, 2010 at 06:50 AM Blackhawk-17
Thanks Blackhawk. I used the WITH MOVE clause and it worked. Action taken: restore filelistonly from disk='D:\Temp Files\Name_Of Trans_Log.trn' to list the files in the trans log backup, the used: RESTORE LOG [Log_Name] FROM DISK = N'D:\Temp Files\Name_Of Trans_Log.trn' WITH FILE = 1, MOVE N'E6-Blank' TO N'D:\Sql Server\data\E6-Database.mdf', MOVE N'E6-Blank_log' TO N'D:\Sql Server\data\E6-Database.LDF', MOVE N'sysft_FT_ESCore_Search_Cache' TO N'D:\Sql Server\data\E6-Database_2.FT_ESCore_Search_Cache0000' NORECOVERY, NOUNLOAD, REPLACE, STATS = 10
Jul 14, 2010 at 06:01 AM mistp001
(comments are locked)
10|1200 characters needed characters left

Looks like you're missing a backslash

'E:SQL Server...' ought to be 'E:\SQL Server...'

That or the path is wrong. Are you trying to restore across the network to a different server? You should use UNC paths for that.
more ▼

answered Jul 09, 2010 at 05:22 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
98.6k 19 21 74

Nice Catch!!
Jul 09, 2010 at 05:46 AM DaniSQL
the backslash was there in the question, its justhidden when displayed. fixed
Jul 09, 2010 at 06:29 AM Fatherjack ♦♦
The backslash on this site is used as escape character. For example, if you need C:\Temp to appear in the text of the answer/comment, you should replace any occurence of the \ with \\. This feature is very handy when you need to escape some characters which have some special meaning, such as *** ** which needs to be typed as **\* ** in order to appear properly because otherwise, the parser will assume that you meant to italize some text. Similarly, ** is used to begin bold text and therefore it also needs to be escaped like this: \*\* In short, the backslash is used as the gentle (Javascript like) escape, not the harsh one (like in C# which will only allow you to escape the characters which must be escaped).
Jul 15, 2010 at 10:50 AM Oleg
(comments are locked)
10|1200 characters needed characters left
are you running this remotely. Is the E drive mapped to the right location, or even exist, on the machine where the restore is taking place?
more ▼

answered Jul 09, 2010 at 06:31 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.4k 75 78 108

I am using Sql Management Studio on the actual server to restore. The backup file is from a different server. I managed to restore from the .bak file with the option of Restore with NORECOVERY. I then try to restore the transaction log with Restore with NORECOVERY option so I can restore subsequent transaction log.
Jul 12, 2010 at 03:53 AM mistp001
(comments are locked)
10|1200 characters needed characters left
Do the SQL Service account have access to the folder you are trying to restore to?
more ▼

answered Jul 09, 2010 at 08:35 AM

sp_lock gravatar image

sp_lock
9.1k 24 28 31

Yes it does. I am using Sql Management Studio on the actual server to restore. The backup file is from a different server. I managed to restore from the .bak file with the option of Restore with NORECOVERY. I then try to restore the transaction log with Restore with NORECOVERY option so I can restore subsequent transaction log.
Jul 12, 2010 at 03:53 AM mistp001
(comments are locked)
10|1200 characters needed characters left
good one Blackhawk,
more ▼

answered Jul 19, 2010 at 02:06 AM

pits gravatar image

pits
830 79 91 92

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1945
x101

asked: Jul 09, 2010 at 05:12 AM

Seen: 2247 times

Last Updated: Jul 09, 2010 at 06:30 AM