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
Hello.
Did you bring over all volumes when you did the P2V? Did any drive letters change?
Good Luck!
Well in fact the problem was not related to the Virtualization at all. We just had a problem with the SQL server agent
cheers