SQLCMD.exe returning error code 1 while creating database(.sql and .bin files).

• reddy.reddappa

  SSC Veteran

  Points: 229

  More actions

  November 5, 2012 at 8:31 pm

  #270461

  Hi,

  I am using SQL Server 2005 Express edition to create Database instance(Named Instance) and create database(executing .sql and .bin file) on the named instance.

  In the above case i succeeded in creation of database instance(Named instance) but while creating database on the instance i am getting error code 1.

  Note:- For creating database instance i am using OSQL.exe and SQLCMD.exe. Using OSQL.exe i am executing .sql files and using SQLCMD.exe i am executing .bin files.But i am not facing any issue with OSQL.exe i am facing issue with SQLCMD.exe.

  Following command i am executing using SQLCMD.exe

  C:\Program Files\Microsoft SQL Server\90\Tools\Binn\SQLCMD.exe -S \InstanceName -d DatabaseName -i C:\database.bin

  the above command returns error code 1.

  If any body knows the root cause please help me ASAP.

  Thanks in Advance.