Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chris_wood99
Yak Posting Veteran
70 Posts |
 Posted - 2005-08-12 : 10:30:55
|
| Hello I am attempting to move a info from the production system into a test environment so the development team have a new refresh of recent data every morning.It is a fairly small db so i'm not that bothered about the performance of the transfer.I have been trying to simply use the transfer database task but after imputting the relevant details i am receiving a useful 'unspecified error' message when running the package. I am using the same domain admin login to login to both servers and can before data transformations between the servers so don't think its permission related.I then tried instead to simply export all the objects into the test envionment and select to overwrite all objects and data if it already exists. when running this process i get am message '<login> user already exists in the current database' even if no database exists when the dts run begins!any help with these or a link to a good step by step guide to DTS packages for beginners would be great! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-12 : 13:58:56
|
| Using DTS for this is not the best approach. The best approach is to backup the production database using BACKUP DATABASE, copy the BAK file to your test system, then perform a restore using RESTORE DATABASE. You possibly will need the WITH MOVE option of the RESTORE command if the location of the MDFs and LDFs will be different than the source.Tara |
 |
|
|
|
|
|
Moving databases across servers with DTS Packages