The forum will be down for maintenance at some point from Friday, November 16 at 19:00 EDT until Sunday, November 18 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

Hi all,

Let me know if I can populate an empty DB from a log file of a full-DB (structurally identical).

My situation is this:

I have an empty DB, I do a backup and copy it to another server. After the first DB is populated, I stop it and copy it on another server. I start DB on second server with the log files generated on the first server. My question is, can the empty DB be populated from the log file?

Is this operation is allowed on ASA 9.0.2.3340.

asked 21 Apr '12, 06:31

snafuz88's gravatar image

snafuz88
46559
accept rate: 0%

edited 21 Apr '12, 08:22

Mark%20Culp's gravatar image

Mark Culp
23.8k9134279


Use "dbsrv9 copy_of_original_db.db -a populated_log_file.log".

If you created an extra log file during your first backup, you should apply that one before the populated log. Alternatively, just copy your original empty database rather than doing a backup.

permanent link

answered 21 Apr '12, 07:38

John%20Smirnios's gravatar image

John Smirnios
9.5k381121
accept rate: 39%

Just to add: The reason this has to work is that this is a common recovery situation, namely when the "current database file" is lost (cf. this v12.0.1 doc page:

You would then use you "old database backup" (here: copy_of_original_db.db) with the current transaction log (here: populated_log_file.log) to bring your database to the current state. The only requirement is that the populated_log_file.log has originally been used with the old/original database file.

(21 Apr '12, 14:21) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×48
×23
×15

question asked: 21 Apr '12, 06:31

question was seen: 1,394 times

last updated: 21 Apr '12, 14:21