dbTalk Databases Forums  

DTS Package to Duplicate Backup/Restore?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS Package to Duplicate Backup/Restore? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ML
 
Posts: n/a

Default 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?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.