on 04-29-2014 8:38 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI JA
Refer the YouTube video
How-To: Backup a Database Using SQL Server Management Studio - YouTube
Regards
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.