Skip to Content
J A

SQL Server Backup

Hello,

For the moment I need to take some backups for a SAP system, however, I got the following questions:

- If I want to use DBACOCKPIT (DB13), Can I backup the files to disk? When schedulling I only got Device Type = Tape (R3DUMP0,1,2), I got the same problem with DB Logs.

- Do I need to backup also the other databases: MASTER, MSDB, TEMPDB, Model?

Regards,

JAM

Information:

-SQL Server 2012 SP1

-Windows Server 2008 R2

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Apr 30, 2014 at 03:47 PM

    JAM,

    To go back to your first question, yes you can back up to a disk device using DBACOCKPIT. To do so, you must first use the SQL Management Studio to create the backup device.

    Note, for this example I just quickly created a temporary device to illustrate. In reality, you would want to create several backup devices to accommodate full backups, differential backups, transaction log backups, master/msdb backups, etc. This is just to show that it can easily be done.

    Anyway, once you have created the device in SQL Management Studio, it will now show up as an available device in DBACOCKPIT.

    Now you can use DBACOCKPIT to schedule backups.

    This should get you started with the mechanics of how to use DBACOCKPIT to schedule full, differential, and transaction log backups of your SAP database, as well as full backups of your master and msdb databases. As Shkelzen said, these last two are also critical to back up, but TempDB is not critical (it is recreated automatically whenever SQL Server starts, so there's no point). Model is important to have one backup of, and then you only need to get a new one if you make a change to it, as this is just a template for creation of new user databases, and you will probably never actually modify it for SAP usage. However, the SQL Management Studio maintenance plan for backing up system databases will by default include this, and as it's so small, it is of no cost to do so.

    The exact design of an excellent backup strategy is another question. This is about the mechanics of setting it up, not the plan.

    Regards,

    Matt


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 29, 2014 at 08:07 PM

    Personally, I prefer to use the SQL Management Studio to setup the backup jobs. DBACOCKPIT is able to read the backup/restore history and job information just fine, so it's not a problem.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 29, 2014 at 09:49 PM

    Regarding the second question...

    You cannot backup TEMPDB.

    The other system databases need not to be backed up as often as the database your system is using but still you need to take care of their backup too as they have important information about your Server.

    Back Up and Restore of System Databases (SQL Server)

    Best regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 30, 2014 at 08:38 AM
    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.