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

avatar image

mistp001
3 2 2 3

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

avatar image

Blackhawk-17
12k 30 35 42

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

avatar image

Grant Fritchey ♦♦
137k 20 42 81

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

avatar image

Fatherjack ♦♦
43.7k 79 97 117

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

avatar image

sp_lock
10.5k 27 37 37

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

avatar image

pits
830 89 92 95

(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.

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:

x2016
x122

asked: Jul 09, 2010 at 05:12 AM

Seen: 2683 times

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

Copyright 2016 Redgate Software. Privacy Policy