"Albert" <Alb***@discussions.microsoft.com> wrote in message
news:0AC5AF0F-F3B7-4964-8C44-D57054C64DCB@microsoft.com...
> How can you backup a sql database to a different server if the sql server
> is
> installed on a standalone workgroup server?  The issue is that there are
> several sql servers each installed on stand alone workgroup servers.  We
> want
> to be able to automate a backup of the all the databases on all the sql
> servers to a single server.  When we try this, we get errors whether the
> single server to be backed up to is another workgroup server or one on a
> domain.  Is there a way to do this?  If not, what needs to change in order
> to
> make it work?
>
> Thanks.

"Geoff N. Hiten" wrote:

> Microsoft has an excellent system for centralized security management called
> "Active Directory".  It is primarily designed to allow individuals,
> services, and machines uniform access to resources located on different host
> computers.  I would bring the servers into a domain or a series of trusted
> domains and manage access that way.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
>
> "Albert" <Alb***@discussions.microsoft.com> wrote in message
> news:0AC5AF0F-F3B7-4964-8C44-D57054C64DCB@microsoft.com...
> > How can you backup a sql database to a different server if the sql server
> > is
> > installed on a standalone workgroup server?  The issue is that there are
> > several sql servers each installed on stand alone workgroup servers.  We
> > want
> > to be able to automate a backup of the all the databases on all the sql
> > servers to a single server.  When we try this, we get errors whether the
> > single server to be backed up to is another workgroup server or one on a
> > domain.  Is there a way to do this?  If not, what needs to change in order
> > to
> > make it work?
> >
> > Thanks.
>
>
>