Newbie question

I have installed MSDE2000 since a couple of weeks on my machine and its
running the database for a forum on the intranet. Could someone please tell
me, how can I make a regular back up of my database please?
Regards
Rahul
hi Rahul,
"Rahul Kumar" <rahul.kumar.remove_it@.sage.remove_it.com> ha scritto nel
messaggio news:eQTRboBlEHA.3536@.TK2MSFTNGP12.phx.gbl...
> I have installed MSDE2000 since a couple of weeks on my machine and its
> running the database for a forum on the intranet. Could someone please
tell
> me, how can I make a regular back up of my database please?
as MSDE does not provide graphical management utilities, you should resort
on Transact-SQL statement execution via oSql.exe, the command line
management tool available and bundled with it...
further info on how to use it can be found at
http://support.microsoft.com/default...;EN-US;q325003
for your convenience, you can have a look at a free prj of mine, available
at the link following my sign., which porvides a user interface similar to
Enterprise Manager, that includes that feature, graphically
further MSDE management tools, both free and commercial, can be found at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
google for others
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Adrea! That was a great help!
Regards
Rahul
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2q3b2oFq9t8lU1@.uni-berlin.de...
> hi Rahul,
> "Rahul Kumar" <rahul.kumar.remove_it@.sage.remove_it.com> ha scritto nel
> messaggio news:eQTRboBlEHA.3536@.TK2MSFTNGP12.phx.gbl...
> tell
> as MSDE does not provide graphical management utilities, you should resort
> on Transact-SQL statement execution via oSql.exe, the command line
> management tool available and bundled with it...
> further info on how to use it can be found at
> http://support.microsoft.com/default...;EN-US;q325003
> for your convenience, you can have a look at a free prj of mine, available
> at the link following my sign., which porvides a user interface similar to
> Enterprise Manager, that includes that feature, graphically
> further MSDE management tools, both free and commercial, can be found at
> http://www.microsoft.com/sql/msde/partners/default.asp and/or
> http://www.aspfaq.com/show.asp?id=2442
> google for others
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>