Basic Restore Question

[Former Member]

I don't know much about basis, but I have a development box that is backed up every evening in an offline backup using transaction DB13.

How do I restore using the resultant file? This is not a critical system, and it doesn't warrant a full-fledged basis consultant. But we would like a way of restoring if possible.

Thanks for any replies.

[Former Member]

The online help-files contain some good instructions on how to restore a saved backup. DB13 is a standardized interface to whatever database you have. If you use SQLServer it uses one set of commands. If you have Oracle it uses another set of instructions.

So at the end of the day its really just a database operation to restore the saved DB files. There are a number of ways to do it from manually restoring the files with command lines. You might be able to use SAPDBA or BRRESTORE. I think SQLServer has some pretty easy tools.

The answer hinges on which database you're using.

[Former Member]

Please review these OSS notes for MSSQL:

Preconditions:

67320 Basic knowledge of MS SQL Server

80102 Device Management for MS SQL Server

Strategies:

44449 Backup strategies with SQL Server

50990 DB-Backup/Restore of Microsoft SQL Server

Performing:

77434 New sched. calendar in the CCMS (DB13) SQL Server

50745 Database Restore for SQL Server

67437 DBCC checks

Related notes:

77497 Backup via DB13 fails with SQL error 3206

68818 Error in SQL Server Backup/Restore

50768 Error in LOAD HEADERONLY (Parallel Backup)

70161 SQL Error 916 and 4001 after Restore

67297 SQL Error 1105

87027 Fill level of the database and log

48585 Database copy

81692 Suspect database

Please review these notes for Oracle:

4157 General flowchart for ORACLE recovery

391 Archiver is stuck

4160 Tape management at recovery

4161 Full recovery

4162 "END BACKUP" missing

4163 Defective redo logs

4164 Incomplete recovery

4165 Recovery after structure changes

4190 Defective rollback segments

5701 RESTORE of the database (partial or complete)

19914 Subsequent processing after incomplete recovery

23070 Backup and Recovery: Basic Concepts

Please award points if you find these helpful.

Regards,

Sanket

[Former Member]

hi, Jerry:

Backup data contains operation system files and database data. I do not know which data you want to restore. Database data contains database structure data, database data files and log files. Restore is based on which data you lost.

Can you give some detailed information about opertation system type and database type ?