Hi Folks,
what can I do if I want to restore a database that has several db file but I want to restore them onto a different server that has a totally different drive structure. Furthermore I forgot how many dbfiles are in the original backup and also what the name of the db files were. It seems I cannot move the files because I do not know the names of the files or how many file there are
e.g
RESTORE DATABASE [test]
from disk '.....'
WITH RECOVERY, REPLACE, MOVE to ,
MOVE
to
the problems are with the move as it needs and I have forgotten (hypothetically) what it was. Can anything be done here?