DTS Package to Duplicate Backup/Restore? -
08-21-2005
, 08:20 AM
Is it possible to create a DTS package that would basically duplicate what
backup/restore does?
Basically I have a remote SQL Server database on a hosted server that I do
not have direct backup/restore rights too. What I need to do is have a way
to backup and restore this server to a local development SQL Server.
What is the best way to do this with DTS so that it completely copies all
object and data between systems? |