Solved

OSQL installation

Posted on 2010-09-13
2
943 Views
Last Modified: 2012-05-10
Hi;

My application require "osql.exe" to backup SQL database from SQL2005 server, how can I install "osql.exe" on to the application server without installing the entire package of SQL 2005?

I tried to select the Client Management Tool only from SQL 2005 Cd but does not work.
0
Comment
Question by:KANEWONG
2 Comments
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 125 total points
ID: 33665534
OSQL is specific to SQL 2000.  You should be using SQLCMD for 2005+.
0
 
LVL 8

Assisted Solution

by:mustaccio
mustaccio earned 125 total points
ID: 33665866
You can download the command line client (SQLCMD, as BrandonGalderisi mentioned) from the feature pack page at http://www.microsoft.com/downloads/en/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=enhttp://www.microsoft.com/downloads/en/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

You will need both                         SQLServer2005_SQLCMD.msi and                         sqlncli.msi (native client libraries).
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question