If I may ask you another question. Do you think the problem is that I don't have this database (MYDATA) in the Databases of my SQL Server? That is, I am running the command RESTORE FILELISTONLY against a backup copy of the database done on another server.
Thank you.
>If you're running the Query Analyzer on your PC it looks for E: drive on your PC not on the server.
>
>
>>When I attempt to run the following command in the Query Analyzer:
>>
>>RESTORE FILELISTONLY FROM DISK = 'E:\MyFolder\MYDATA backup'
>>
>>
>>I get the following error:
>>
>>
>>Server: Msg 3201, Level 16, State 2, Line 1
>>Cannot open backup device 'E:\MyFolder\MYDATA backup'.
> Device error or device off-line.
>See the SQL Server error log for more details.
>>
>>
>>There is a physically a file "MYDATA backup.bak" in the folder "MyFolder".
>>
>>Please suggest where to read description of the Msg 3201 and so on.
>>
>>Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham