Hi
sql 2005
I have to take a Backup of a table from prod instance and restore the same in Reporting instance.
this process should be automated, kindly tell me the beset way of doing .
Note:- SSIS is not recommended in our organization, please dont suggest that. Suggest me some best solution.
Thank you
Hemadribabu