• Dird:

    I don't think a remote backup is really required. How many disks does your server have? Assuming there's one spare for backups you could just do this to maximise reliability:

    Norbert:

    Both servers have RAID 5: 4 hard disks each.

    Dird:

    backup to backups to 2-3 different locations. e.g. lets say you have your main machine (named SV01), the other one you mentioned (SV02) and managed to find another computer that has quite a bit of free space & isn't used that much (SV03). and your work computer (DRNOR) also has quite a bit of space. You would then be able to do this:

    BACKUP DATABASE DATA2007 TO DISK='E:\backups\db.bak'

    MIRROR TO DISK='\\SV02\backups\db.bak'

    MIRROR TO DISK='\\SV03\backups\db.bak'

    MIRROR TO DISK='\\DRNOR\backups\db.bak'

    Your backups are then copied to 4 different computers (the first is on the database server)...you'd have to be pretty unlucky for all 4 computers to have hardware failures on the same day The same process can be done with the transaction logs too.

    Norbert:

    This is a great solution.

    This command are execute in a query?

    Dird:

    I think email alerts is easy to set up if your company already has an SMTP mail server. I've never done it but if you have the details it should just be filling them into the Database Mail config wizard. You can ask someone at work whether you have SMTP there. If so then YouTube should have short videos for configuring the Database Mail feature.

    Norbert:

    No SMTP server. Can we use an live.com?

    I can't find YouTube for configuring the Mail feature.

    Dird:

    You will probably want to backup every 15-30 minutes then to limit the potential loss.

    Norbert:

    Thanks make sense.

    Dird:

    There is but if you're doing things "by the books" then this would probably cost a lot of money because of the licensing fees. I don't know of the license fees for Database Mirroring; this would be something for you to look at. I also don't know if the Enterprise Edition fee is a one-off payment or an annual charge. Whoever arranged for EE at your company will have a better idea on how the license costs work.

    - If it is a one-off payment then I think they would be reluctant to pay an additional charge for mirroring.

    Norbert:

    We have already in both servers SQL with all the licenses.

    No one else is in the company to advise, I am kind of stuck.

    Do you know any reference of how to figure out Database Mirroring?