|
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).
E drive does not exist on this server.
(comments are locked)
|
|
It appears that there is a Full Text catalog referenced in the restore. Does the following path exist on the new server: E:SQL ServerInstallMSSQL.2MSSQLFTData ? If not, try and create that and copy the directory at the file-system level first. Unfortunatly, the E drive has been assigned to CDROM. Is there any other way ????????
Jul 12 '10 at 06:44 AM
mistp001
Use the WITH MOVE clause of your restore to set the FT Catalog to a valid location.
Jul 12 '10 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 '10 at 06:01 AM
mistp001
(comments are locked)
|
|
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. Nice Catch!!
Jul 09 '10 at 05:46 AM
DaniSQL
the backslash was there in the question, its justhidden when displayed. fixed
Jul 09 '10 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 '10 at 10:50 AM
Oleg
(comments are locked)
|
|
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? 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 '10 at 03:53 AM
mistp001
(comments are locked)
|
|
Do the SQL Service account have access to the folder you are trying to restore to? 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 '10 at 03:53 AM
mistp001
(comments are locked)
|
What's your method of restoring? Parameters?
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.