How to take back up using query analyzer  
Author Message
tasmith00





PostPosted: Tue Dec 13 06:58:33 CST 2005 Top

SQL Server >> How to take back up using query analyzer

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

SQL Server284  
 
 
Mike





PostPosted: Tue Dec 13 06:58:33 CST 2005 Top

SQL Server >> How to take back up using query analyzer Answered in microsoft.public.sqlserver.programming

Please do not multi-post.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland



MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/



> 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
>