Restore database from dat file

• peer_mohamed2k

  Mr or Mrs. 500

  Points: 510

  More actions

  June 19, 2008 at 4:58 am

  #192943

  Hi,

  I have A.dat file. Using BCP How to restore file to a new database.

  I am trying in this way.

  BCP ASPT in -iA.dat -t

  Here ASPT is new databse name. It throws 'Object Not found' error.

  Can anyone help on this?

  Thanks,

  Peer Mohamed.

• Vidhya Sagar

  SSCrazy Eights

  Points: 8216

  More actions

  June 19, 2008 at 5:28 am

  #830994

  Hi,

  You can try the below query. I'm connecting to the localserver using windows authentication

  bcp ASPT.dbo.tablename in A.dat -T -c

  Please note that you need to provide the table name to import the data, if the table doesnt exist, create the table with proper structure!!

  Regards..Vidhya Sagar
  SQL-Articles

• KenpoDBA

  SSCrazy Eights

  Points: 9811

  More actions

  June 19, 2008 at 8:36 am

  #831146

  I've got a set of BCP tutorials on my MidnightDBA site below. Go to the admin section and I think they're near the top.

  Watch my free SQL Server Tutorials at:
  http://MidnightDBA.com
  Blog Author of:
  DBA Rant – http://www.MidnightDBA.com/DBARant

  Minion Maintenance is FREE:
  
  

• magasvs

  SSCertifiable

  Points: 7660

  More actions

  June 20, 2008 at 6:15 pm

  #832142

  One of the clients sent me backup file once with .dat extention. I just restored it as regular backup. This may not be your case though.

• Manoj-485464

  SSCrazy

  Points: 2717

  More actions

  June 23, 2008 at 1:47 pm

  #833004

  peer_mohamed2k (6/19/2008)

  ---

  Hi,

  I have A.dat file. Using BCP How to restore file to a new database.

  I am trying in this way.

  BCP ASPT in -iA.dat -t

  Here ASPT is new databse name. It throws 'Object Not found' error.

  Can anyone help on this?

  Thanks,

  Peer Mohamed.

  Bcp dbo.ImpTst in 'D:\ImpData.txt' -T -S serverNameinstanceName

  Manoj

  MCP, MCTS (GDBA/EDA)