Ask a questionAsk a question
 

Questionvb

All Replies

  • Thursday, July 23, 2009 8:12 PMluisnike19 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi, it could be many ways to do this task, I think that the best way is to create a store procedure that makes this action.


    BACKUP DATABASE DatabaseName TO DISK 'C:\backup.bak'
    WITH FORMAT;
    GO

    then call that procedure when each week with VB.