sql server dts: SQL Server 7 box in a workgroup DTS'ing data to a server in a doma -- sql server dts

SQL Server 7 box in a workgroup DTS'ing data to a server in a doma

KnightFall1
3/30/2005 11:13:02 AM

sql server dts:

Is it possible to setup DTS in SQL Server 7 in such a way to make a copy of a
local database that is sent to a file share in a domain for archival
purposes? Because the server doesn't meet certain company security
requirements, the requirement is that it be moved into a workgroup. I am
attempting to find a way to at least to backup the SQL databases to some
location since our enterprise backup software won't backup servers that

Re: SQL Server 7 box in a workgroup DTS'ing data to a server in a doma

Allan Mitchell
3/30/2005 9:21:55 PM

SQL Server will backup databases on a workgroup and a domain yes. You
do not need DTS at all to do this.

So long as the "Archiving" server can see the network share then you can
fire the backup across the wire.

Allan

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.