Logical file ‘AdventureWorks2012_Log2’ is not part of database ‘AdventureWorks2012’. On executing I got an error as expected, shown below: MOVE N'AdventureWorks2012_Log2' TO N'E:\MSSQL11\Log\AdventureWorks2012_Log2.ldf', MOVE N'AdventureWorks2012_Log' TO N'E:\MSSQL11\Log\AdventureWorks2012_Log.ldf', MOVE N'AdventureWorks2012_Data' TO N'E:\MSSQL11\DATA\AdventureWorks2012_Data.mdf', I created the RESTORE script and added another line of log file at line 8 below:įROM DISK = N'E:\Softwares\MS_bits\AdventureWorks2012.bak' WITH FILE = 1, –> I took a backup of AdventureWorks2012 Database on my machine. Let’s try to reproduce it in a standalone box: And as I was using the same old script to Restore it, I was getting this error. The error message says to use “RESTORE FILELISTONLY”, I check the syntax on MSDN and found that this Database had two log files (LDF) earlier, but now configured for only one. Finally I picked it up again and saw that some new kind of error I was facing. I restored other Databases and left this one to do at the end. Suddenly in between I came across an error which didn’t let me restore a Database. I was restoring Databases as a routine monthly job.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |