Re: osql command reference?

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 15:57:16 +0530

Hi,

Books online is the best option to learn all commands and usage.

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

* the complete desciption of BACKUP and RESTORE

See backup and Restore in books online

 * a way to show the table definitions.

sp_help <table_name>

* OSQL

See OSQL in books online 

--
Thanks
Hari
MCDBA
"Stefan M. Huber" <looseleaf@gmx.net> wrote in message
news:opsbdo75yjs9ddfw@news.individual.de...
> Hi!
>
>    I have been looking for a complete command reference to osql. A
document
> that describes all possible SQL commands that you acn use. Unfortunately,
> I seem too stupid :/
> I haven't found:
> * the complete desciption of BACKUP and RESTORE
> * a way to show the table definitions.
>
> TIA,
> Stefan

Relevant Pages

  • Re: ADP SQL Database Backup
    ... I'll check my clients SQL Server 2005 Express installation to see if I see ... UTILITIES menu to Backup, Copy and Restore SQL Server Databases. ... I found the Docmd.TransferSQLDatabase and Docmd.CopyDataFile commands, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: dropped tables
    ... We Restored from the last backup 12 hours prior... ... Restore it from a backup if you have one. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: RMAN
    ... the commands. ... different backup pieces and one backupset) ... restore the files are smaller to read and the restore will be quicker. ... an exact configuration yet.) ...
    (comp.databases.oracle.server)
  • Re: newb SQL Server question
    ... >complete backup of a database, then restore only certain tables. ... description of BACKUP and RESTORE in Books Online). ...
    (microsoft.public.sqlserver.setup)
  • Re: Help - Very Odd Restore Issues
    ... I am now doing a new backup to only one backup ... >as try RESTORE VERIFYONLY command. ... >Syntax of both commands: ... >> I am trying to restore a db to my testing server. ...
    (microsoft.public.sqlserver.server)