We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-basis] SAP on SqlServer 2008 Backup Procedure

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by cranece (DBA / Basis )
on Jan 13 at 10:56 AM
Well it will depend on the size of the database. In my case we do a daily full backup of the database and we backup our transaction logs every 15 minutes.

Then my system managers backup the servers (both application and database) plus move the SQL server back up from disk to tape daily. When backing up the database server they do not include the database files.

For the database backup itself, you can create a maintenance job that will do many things for you besides backup the database. You can clean up 'old' backup files, you can 'update stats' and verify databases,etc. Or you can write a script.

I keep two database backups on disk and a week's backups on tape. For transaction logs, I keep enough to cover the backup files in case of a restore.

The duration of my SAP database backup is ~8 hours without any verifies or stat updates. I am at the point where I will next go to differential daily backups and a full once a week as 8 hours is the extreme limit I can take.

Hop this helps

---------------Original Message---------------
From: Raj
Sent: Thursday, January 13, 2011 10:17 AM
Subject: SAP on SqlServer 2008 Backup Procedure

Can some one please explain the detailed procedure of taking sap full backup on sqlserver 2008?

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
Most Popular White Papers

In the Spotlight
Which response to your Toolbox.com Groups post was the most helpful? Use 'Best Answer' to mark highest quality content.
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language