SQL Server Performance

Backup automation and archive old back up

Discussion in 'SQL Server 2008 General DBA Questions' started by Joben, Dec 6, 2010.

  1. Joben New Member

    Hi Friends,
    I need to set up a process which would take a full and transactional backup everyday and automatically overwrite the previous days backup. Can some body please suggest me the best way. I would really appreciate your help.
    Thanks,
    Joben
  2. sani New Member

    Hi,
    Maintenance Plans provided the best & easy solution for Backup Data/Log.
    Sani.
  3. satya Moderator

    True, there are few articles on this website under Articles section where you can find the detailed information.

Share This Page