rebuild environment | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

rebuild environment

i wanna be able to click a button and my STG envionment is fully refreshed from my TST environment. (the whole database) i tried the sql server 2005 integration services transfter sql server objects task. but there is a bug in that task and MS is working it. (Bug with identity fields) what other options do i have with sql server 2005?
– script a backup, restore
– ? i want to be able to rebuild STG like 2-3 times a month
IMO, backup/restore is the simplest solution.
CHeck the relevant hotfix for SSIS in this case and i second Mirko’s option to use the backup & restore method. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.