Import Dump File

Hello,
I need to import a dump file (.dmp) and create a database from that. I
cannot find the syntax in the SQL Server books online.
If anyone konws, could you please tell me the sql syntax for importing a
dump file and creating a database from it.
Thanks in advance for your help,
Steve K.
Hi
Asszuming it is a SQL Server 7.0 or 2000 dump (backup), that you want to
restore to SQL Server 2000
RESTORE DATABASE dbname
FROM DISK = 'path and file goes here'
WITH RECOVERY
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Steve Kitley" wrote:

> Hello,
> I need to import a dump file (.dmp) and create a database from that. I
> cannot find the syntax in the SQL Server books online.
> If anyone konws, could you please tell me the sql syntax for importing a
> dump file and creating a database from it.
> Thanks in advance for your help,
> Steve K.
>
>
|||Thanks Mike,
I used the 'with move' command with what you said and imported the data just
fine.
Best regards,
Steve K.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:BA6E1CFC-CD29-4B27-8E09-A030D072E0B7@.microsoft.com...[vbcol=seagreen]
> Hi
> Asszuming it is a SQL Server 7.0 or 2000 dump (backup), that you want to
> restore to SQL Server 2000
> RESTORE DATABASE dbname
> FROM DISK = 'path and file goes here'
> WITH RECOVERY
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Steve Kitley" wrote: