Saving automatically a data base in SQL server EXPRESS 2008 R2 RRS feed

  • Question

  • hi everybody, 

    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. 

    Best regards, 

    Monday, April 16, 2012 11:03 AM


  • This is certainly not the correct forum to be asking your question.   Please re-post your question in a more suitable forum, such as this one.
    • Marked as answer by Challen Fu Monday, April 30, 2012 9:15 AM
    Tuesday, April 24, 2012 8:56 PM