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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Strategies » SQLCMD.exe returning error code 1 while...

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

Rate Topic

Display Mode

Topic Options

Author

Message

reddy.reddappa

Posted Monday, November 05, 2012 8:31 PM

Forum Newbie

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

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.

Post #1381351

« Prev Topic | Next Topic »

Permissions