Skip to Content
author's profile photo Former Member
Former Member

Idea of backup

Does anyone has experience in performing this kind of backup?( I have ECC 5.0 running on Win/SQL)

Image of whole windows system(after every windows system change)

MS SQL backup of SID database(daily)

In the case of emergency I could restore image of windows and

actualize SAP data with MS SQL restore

Thank you in advance

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jan 02, 2007 at 12:49 PM

    Tina,

    I have used this type of backup before, it can work quite well but you need to be aware of the following things.

    Most important

    A recovery operation does not always require the full restoration of the O/S and really the best way to look at any operation in a recovery is "What will give me the biggest benefit for the least amount of effort"

    1. Your image of the windows operating system needs the following considerations

    A. If you restore the image, it needs a hardware platform as close the original as possible. This is so that you do not spend time troubleshooting driver issues. Remember an O/S build really only takes around 1-3 hours (depending on service packs and install method). So to make this image method efficient, the process needs to be completed within 1 hour.

    B. The storage of your image, most servers do not have DVD drives (they do come with them now though) So the medium for restoring your image is also an issue. How are you going to be able to restore 2-4Gb of an image file when you do not have some method of accessing it from the server. You can use the network if your imaging application supports it, or you can use an external USB harddrive, but only if the server has USB 2.0 ports (they can handle the data transfer rates required). Also you need to consider where exactly you will store the image, as it cannot be deleted.

    The next point about a daily backup of your Database, you now have to consider your recovery method.

    1. Dev databases (with agreement from the Business and Developers), can be switched into the Simple Recovery mode. This means that they use the transaction log, but once a transaction is completed they truncate the log and so it does not need backed up. Because they do use the log, it needs to be of sufficient size though. You then backup this database daily to enable a complete recovery record.

    2. QAS Databases, depending on the importance of the database, you could use the simple recovery method or you could use a combination of Transaction log and Database backups to ensure a point in time recovery. It is really up to you and the system stakeholders.

    3. PRD Database, the only acceptable way to backup your Production databases is to use Transaction log and Full database backups. This ensures the point in time recovery, how often you perform your transaction log backups depends on the activity on the system. But a good rule of thumb is to look at how long it takes for your system to fill a transaction log file of 2-4Gb. For most systems I have found that a transaction log backup every hour is sufficient for normal operations. If the system is under load, a second backup on the half hour is scheduled.

    I hope this helps

    Chris aka BoobBoo

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2007 at 09:56 PM

    Yes. That will work but to get good system backups you should really look at tools that will do incremental backups of files that will change on the system. A full system image is nice to have for recovery but if you don't have incrementals you will find that various files are out of synch and it may be hard to recover. For a dev or sandbox environment imaging your server is probably ok if you do it frequently and your willing to loose some changes at the operating system level.

    Lee

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.