Post reply

Import in SQL Server

  • January 21, 2002 at 11:41 am

    #158032

    I am used to importing a .dmp file in Oracle. I have a back up file from a client of their database. I want to 'import' or restore this to my local database so I can test. I have a file they call backup but it does not have any extension I recognize and the restore fails when I try by file/file group. Any suggestions? Any correlation to ORacle will help me understand.

    Thanks.

    Regina O.


    Regina O.

  • January 21, 2002 at 11:57 am

    #422383

    there is no extension required in SQL Server. In EM, you can select the file restore and "pick" the file. If it does not show up, you can manually specify the name. Most times, people use .bak for sql server.

    Steve Jones

    steve@dkranch.net

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply