VMware Cloud Community
jyvesd
Enthusiast
Enthusiast

Atfer a P2V concersion we get 'cannot find the file ID 2 on device' error when trying to restore a dB

We did a P2V conversion of a SQL server. Everything went fine and the application seems to work properly but now when we try to restore a back-up we gat the following error message

Microsoft SQL-DMO (ODBC SQLState: 42000)

'cannot find the file ID 2 on device RESTORE DATABASE is terminating abnormally'

Did someone experience this error after a P2V (We did test on the physical source server and there everything work fine)?

thx

0 Kudos
2 Replies
vmroyale
Immortal
Immortal

Hello.

Did you bring over all volumes when you did the P2V? Did any drive letters change?

Good Luck!

Brian Atkinson | vExpert | VMTN Moderator | Author of "VCP5-DCV VMware Certified Professional-Data Center Virtualization on vSphere 5.5 Study Guide: VCP-550" | @vmroyale | http://vmroyale.com
jyvesd
Enthusiast
Enthusiast

Well in fact the problem was not related to the Virtualization at all. We just had a problem with the SQL server agent Smiley Happy

cheers

0 Kudos