Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQLCMD.exe returning error code 1 while creating database(.sql and .bin files). Expand / Collapse
Posted Monday, November 5, 2012 8:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 6, 2012 5:23 AM
Points: 1, Visits: 8

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.
Post #1381351
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse