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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 automating data refresh

Author  Topic 

pvsramu
Starting Member

17 Posts

Posted - 2007-05-24 : 10:47:16
Frequently we get request of data refresh. Its curbersome process everytime to take backup from prod and restore in development/test region. I am thinking to automate this process using stored procedure. But I need to pass various parameters to SP to tell where is source, destination, domain, etc.,


Anyone has better ideas/suggestions. Do you have any script reg.


Thanks,
Ramu

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-05-24 : 10:54:32
http://weblogs.sqlteam.com/tarad/archive/2007/02/26/60120.aspx

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page
   

- Advertisement -