I have a real time database and backup database. I want to create a DTS package to copy the data from real time to backup in bulk mode.You might think about using standard backup and restore, it is faster than a DTS copy of any sort. I use a utility called robocopy from one of the res kits for Windows to copy only the new files to a remote server (tran logs and backups)
HTH|||you can use log shipping to transfer transaction logs to another server
No comments:
Post a Comment