Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1630
  • Last Modified:

Cannot find file ID 2 ... Restore Database is terminating abnormaly

Hi there,

I am trying to load a backup from my online server to my local but keep getting the error in the title of this question.

In the title of the error it says MIcrosoft SQL-DMO (ODBC SQL State: 42000)

Would anyone be able to help me with this?

Cheers,

Fracture
0
Fracture
Asked:
Fracture
1 Solution
 
crescendoCommented:
The error means that your log file (.ldf) does not exist by the name in the backup, so your online server and local server must be set up slightly differently.

If you know where your local log file is, you can use restore with the MOVE option.

RESTORE LOG database_name
FROM < backup_device >
MOVE 'logical_file_name' TO 'operating_system_file_name'
0
 
FractureAuthor Commented:
Cheers mate,

That works great!

Thanks for your help

Fracture
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now