A third party is posting a .bak file to their ftp site for us to pick up and
import into our own sql server. Since we did not backup the original
database from our local sql server, how do we restore this new .bak file to
our own sql server? Or is there some other way to do the import- either
through EM or QA?

Thanks in advance for your help ...

bill

Following worked fine - db 'support' was backed up on one sql server as
tester.bak and then restored to another off-site sql server with the
following command:

restore database support
from disk='c:\tester.bak'

Looks like all data restored fine.
sp_helpdb showed the new data files set up okay. If I'm missing something,
please let me know. Thanks ...

"WCM" wrote: