how to take back up

Hi
Can anybody tell me how to take database back up using query analyzer in sql
server 2000?
i dont want in enterprise manager i wnat to know how to do it with query
analyzer.
can you tell me y i'm getting this error when i'm trying to open enterprise
manager
"SQLDMO has not been registered, please re-run SQL SERVER setup and contact
your system administrator"
i can re-run setup but i need to take back up first and it is not giving any
error when opening sql query analyzer.
so can any one tell me
Thanx in advance
JyothiBACKUP DATABASE <dbname>
TO DISK = "d:\temp\backup.bak"
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"yoshitha" <gudivada_kmm@.yahoo.co.in> wrote in message
news:eA81FP%23$FHA.216@.TK2MSFTNGP15.phx.gbl...
> Hi
> Can anybody tell me how to take database back up using query analyzer in
> sql server 2000?
> i dont want in enterprise manager i wnat to know how to do it with query
> analyzer.
> can you tell me y i'm getting this error when i'm trying to open
> enterprise manager
> "SQLDMO has not been registered, please re-run SQL SERVER setup and
> contact your system administrator"
> i can re-run setup but i need to take back up first and it is not giving
> any error when opening sql query analyzer.
> so can any one tell me
> Thanx in advance
> Jyothi
>|||Hi
Check out the description of the backup command in Books online or at
http://msdn.microsoft.com/library/d...asp?frame=true
John
"yoshitha" wrote:

> Hi
> Can anybody tell me how to take database back up using query analyzer in s
ql
> server 2000?
> i dont want in enterprise manager i wnat to know how to do it with query
> analyzer.
> can you tell me y i'm getting this error when i'm trying to open enterpris
e
> manager
> "SQLDMO has not been registered, please re-run SQL SERVER setup and contac
t
> your system administrator"
> i can re-run setup but i need to take back up first and it is not giving a
ny
> error when opening sql query analyzer.
> so can any one tell me
> Thanx in advance
> Jyothi
>
>