I'm running into a problem restoring a database to MSDE.
Actually, osql reports RESTORE DATABASE successfully
worked but when I view the database from enterprise
manager it tells me the database is still "loading..."
Any suggestions?
Sounds like you are using NORECOVERY with the RESTORE command. This will
leave the database expecting additional restores.
Jim
"Tim" <tim.huenke@.ngc.com> wrote in message
news:0f9c01c4dee6$ebe38f60$a401280a@.phx.gbl...
> I'm running into a problem restoring a database to MSDE.
> Actually, osql reports RESTORE DATABASE successfully
> worked but when I view the database from enterprise
> manager it tells me the database is still "loading..."
> Any suggestions?
Showing posts with label osql. Show all posts
Showing posts with label osql. Show all posts
Friday, February 24, 2012
Monday, February 20, 2012
ISQL vs OSQL
Hello
I use SQL Server 2000. I always use Query Analyzer to run scripts, so I don't know OSQL and ISQL. I have some questions.
1. What is difference between ISQL and OSQL?
2. Which one is better?( this question is silly.)
3. What are pros and cons?
4. Which one do most people use?
5. What is a reason to use either of the tools rather than Query Analyzer? (if you use them)
6. Are there any documents (or manuals) about OSQL and ISQL?
7. Any comments?
Thanks in advance.
Do.
Message posted via http://www.sqlmonster.com
Do Park via SQLMonster.com wrote:
> Hello
> I use SQL Server 2000. I always use Query Analyzer to run scripts, so
> I don't know OSQL and ISQL. I have some questions.
> 1. What is difference between ISQL and OSQL?
> 2. Which one is better?( this question is silly.)
> 3. What are pros and cons?
> 4. Which one do most people use?
> 5. What is a reason to use either of the tools rather than Query
> Analyzer? (if you use them)
> 6. Are there any documents (or manuals) about OSQL and ISQL?
> 7. Any comments?
> Thanks in advance.
> Do.
ISQL uses dbLib as its mechanism for connecting to the server and acts
as a SQL Server 6.5 client when connected (legacy application). So you
may not have access to all SQL Server 2000 features. ISQL does not
support unicode.
OSQL uses ODBC as its mechanism for connecting to the server and
supports SQL Server 2000 fully and is unicode compliant.
These are both command-line utilities and are useful when you have to
execute a batch against a database or wish to quickly extract data from
a database using a query.
Use OSQL.
You can read all about them in the help file...
David Gugick
Imceda Software
www.imceda.com
I use SQL Server 2000. I always use Query Analyzer to run scripts, so I don't know OSQL and ISQL. I have some questions.
1. What is difference between ISQL and OSQL?
2. Which one is better?( this question is silly.)
3. What are pros and cons?
4. Which one do most people use?
5. What is a reason to use either of the tools rather than Query Analyzer? (if you use them)
6. Are there any documents (or manuals) about OSQL and ISQL?
7. Any comments?
Thanks in advance.
Do.
Message posted via http://www.sqlmonster.com
Do Park via SQLMonster.com wrote:
> Hello
> I use SQL Server 2000. I always use Query Analyzer to run scripts, so
> I don't know OSQL and ISQL. I have some questions.
> 1. What is difference between ISQL and OSQL?
> 2. Which one is better?( this question is silly.)
> 3. What are pros and cons?
> 4. Which one do most people use?
> 5. What is a reason to use either of the tools rather than Query
> Analyzer? (if you use them)
> 6. Are there any documents (or manuals) about OSQL and ISQL?
> 7. Any comments?
> Thanks in advance.
> Do.
ISQL uses dbLib as its mechanism for connecting to the server and acts
as a SQL Server 6.5 client when connected (legacy application). So you
may not have access to all SQL Server 2000 features. ISQL does not
support unicode.
OSQL uses ODBC as its mechanism for connecting to the server and
supports SQL Server 2000 fully and is unicode compliant.
These are both command-line utilities and are useful when you have to
execute a batch against a database or wish to quickly extract data from
a database using a query.
Use OSQL.
You can read all about them in the help file...
David Gugick
Imceda Software
www.imceda.com
Subscribe to:
Posts (Atom)