I have a question that it is very urgent i want to save 24hours/24 hours a data base automatically and that i restore it from a distant server in order to use it as a history data base . i want to informe you that this base is
automatically erased each 24hours and i want to use it all the time even after 1 mouth or a year. i thought may be there is an SQL script that do this task or should i save it in a text file. Please do me a favor and help with this matter.