use OSQL and the BACKUP DATABASE command

http://www.microsoft.com/sql/msde/pr...o/features.asp

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Kris Leech" <krisleech (AT) interkonect (DOT) com> wrote

You can run DTS Packages on MSDE but you really need Enterprise Manager
(which is not included with MSDE) to design and manage things.

You can use E.M. from a PC that has either Personal SQL Server (more or less
MSDE with Enterprise Manager) or better to manage DTS Packages on an MSDE
database.

Having said that, DTS is probably not the best way to move an entire
database from one machine to another. Either use Enterprise Manager from
another PC (if available) to backup and restore the database or OSQL, as
Alan Mitchell suggests, if E.M. is not available.

It's also possible to detach the mdf and ldf files, copy them to another
machine, and attach to them on the new machine. Again E.M. is the easiest
way to do it and I assume that it can be done from OSQL.

Dick Campbell


"Kris Leech" <krisleech (AT) interkonect (DOT) com> wrote

Thanks both for your reply's that has cleared it up a bit
in my mind. However i dont have OSQL.exe, i have looked in
all folders of the SQL server root folder, but nothing.
Does it come with the install of MSDE or do i need to
download it?

I have MSDE version 8

Many thanks for your time.

Kris.

Thanks Allan, but i get nothing (not reconized internal or external
program or batch file error).. Haveing said that my PATH has been
wiped out by a program i install recently. When should OSQL.EXE be? I
have looked in my Microsoft SQL Server/Binn folder but the only
programs are sqlagent, sqlserver and cmdwrap.

Mnay thanks for your help, Kris.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote