Easy database dump to a file

Hi everyone,
Using SQL Server 2000, what would be the best way to get a dump of a
database that is on a server at a client? I need to be able to say "Here,
run this script/app/command" and it has to be simple enough so that the
person there is able to complete the task. Then, the person will ship me
the dump file so I can have a look at it.
Thanks in advance for any suggestions.
Ericbackup database and the copy the file (.bak) to your workstation
"Eric Caron" <ecaron.nospam@.quebecaffaires.com> wrote in message
news:eEPoz9CbFHA.2520@.TK2MSFTNGP09.phx.gbl...
> Hi everyone,
> Using SQL Server 2000, what would be the best way to get a dump of a
> database that is on a server at a client? I need to be able to say "Here,
> run this script/app/command" and it has to be simple enough so that the
> person there is able to complete the task. Then, the person will ship me
> the dump file so I can have a look at it.
> Thanks in advance for any suggestions.
> Eric
>|||Hi
T-SQL command BACKUP DATABASE and give it to them as a file to run against
OSQL.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Uri Dimant" wrote:

> backup database and the copy the file (.bak) to your workstation
>
> "Eric Caron" <ecaron.nospam@.quebecaffaires.com> wrote in message
> news:eEPoz9CbFHA.2520@.TK2MSFTNGP09.phx.gbl...
>
>