How to Take Backup from Command prompt

Hi all,
Please tell me how to take MS SQL backup from command
prompt.
With regards,
Anna Patil
Generate the BACKUP command you want to run (see the BACKUP topic in Books
Online for syntax and usage). Then, you can save this script in a .sql
file, and run it using osql from the command line. osql has its own topic
in Books Online too, so you can learn how to use it there...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Anna Patil" <anna.patil@.ddsl.net> wrote in message
news:11ee001c4425e$b666b580$a301280a@.phx.gbl...
> Hi all,
> Please tell me how to take MS SQL backup from command
> prompt.
> With regards,
> Anna Patil
|||Hi,
From command prompt execute the below command:-
OSQL -Usa -Ppassword -Sservername -Q"backup database pubs to
disk='c:\pubs.bak' with init"
(replace the database pubs with actual database)
Thanks
Hari
MCDBA
"Anna Patil" <anna.patil@.ddsl.net> wrote in message
news:11ee001c4425e$b666b580$a301280a@.phx.gbl...
> Hi all,
> Please tell me how to take MS SQL backup from command
> prompt.
> With regards,
> Anna Patil