how to import database to sql servermanament 2008

Page 1 of 1

1 Replies - 487 Views - Last Post: 15 July 2012 - 11:14 AM Rate Topic: -----

#1 menukadevinda  Icon User is offline

  • D.I.C Regular

Reputation: -7
  • View blog
  • Posts: 470
  • Joined: 14-April 11

how to import database to sql servermanament 2008

Posted 15 July 2012 - 12:37 AM

HI all,


I have to import a database to microsft sql servermangment 2008 studeio. Problem is I dont know the file format of sql file and How to this with this tool.

when I check the properties of file. it shows '00 File' as the type.

what I tried is created a new database and right click on it and go to task -> restore database.
there it doesnt clear identify the above file gave me a error

Is This A Good Question/Topic? 0
  • +

Replies To: how to import database to sql servermanament 2008

#2 Martyr2  Icon User is offline

  • Programming Theoretician
  • member icon

Reputation: 3872
  • View blog
  • Posts: 11,405
  • Joined: 18-April 07

Re: how to import database to sql servermanament 2008

Posted 15 July 2012 - 11:14 AM

Have you tried opening the file in notepad to see if it is readable at all? If you can't read it, it is probably some sort of binary file in which case I don't think you can directly import it.

Never heard of the file format myself so it could be anything. Perhaps you can tell us where you got the file from? Is it an export file from some other database? What is the actual extension on the file name?

:)
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1