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:

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:
>sql

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...
> 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.
>>

Import Database

Hi all,:confused:

I doing some Online projects...
for that some time i want to import database from online database server(located in Newyork), some time i want to transfer datatabse from one server to another server.
At this time i was used DTS Import/Export wizard, but i am not able to copy the relatioships of the tables(Primary key,foreign key,defaults,views,storedprocedures,triggers).

My query is How i downlod a database with exact structure and all data as it as in remote server.

thanks in advansecan't u use Backup & restore

:)|||thanks for ur rply,,

then how can i import online database to local..with databse structure and data.|||You copy the .bak file from the remote server to the local server and then do a restore.