on 06-24-2013 6:09 AM
Hi Experts,
I am planning to install new system by homogeneous system copy. (Windows 2008 / MS SQL 2008 ) as below.
Now I want to apply transaction logs from system A to newly installed system B every day.
Q: If I follow below procedure, will that be OK?
RESTORE LOG <database name of system B> FROM <backup_device> WITH NORECOVERY;
RESTORE DATABASE <database_name> WITH RECOVERY;
As system B is currently running, Will it be possible to apply transaction logs to system B by above method. I think some think is missing.
Database on System B is already running. Will it be possible to apply logs by above mothod? Please correct my steps.
Regards,
Arpit.
Hi Tony,
We can not use MS SQL log Shipping functionality as there is no connection between system A and system B. We have to manually collect logs and move to system B by media. ftp might not be possible I Guess.
Now, when I recover database on system B by full backup and transaction log backup.
Can I apply Transaction log backup next day to the same database?
I am confused as I am trying to compare the process with Oracle where we used to apply offline backup to DR and then archive logs . But if we opened DR database, then again we have to apply full backup.
I am not sure if I am framing this query properly.
Regards,
Arpit.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tony,
I think you understood my question. Thank you.
As I mentioned , we are performing homogenous system copy. ( from system A to B ).
So database B will be left in online state.
You said, database B needs to be left in a restoring state for daily log backup
I seached online material and found below
A best practice is to restore all the log backups (RESTORE LOG database_name WITH NORECOVERY). Then, after restoring the last log backup, recover the database in a separate operation (RESTORE DATABASE database_name WITH RECOVERY).
But for us transaction log backup will be not available at one time. We need to collect daily and apply it for 15 days.
Then after 15 days , we can recover database and make it online. This approach should work after 15 days else we will waste 15 days.
I think I should follow below approach.
1. We should do system copy and apply transactional logs available. So database B will online.
2. Check if everything is ok with System B.
3. If system B is OK, scrap the system B ( Sap system B and database B )
4. Start system copy again.
5. Apply full backup , restore logs with NORECOVERY.
6. continue applying logs for 15 days.
7. Then recover database after 15 day and complete system copy.
Any thoughts?
Regards,
Arpit.
You are going to want to shut off SAP on system B, then following the below process for transaction log shipping.
http://msdn.microsoft.com/en-us/library/ms190640(v=sql.100).aspx
Microsoft SQL Server has a built in process to do what you want.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arpit,
As per my understanding Database B has to be running for logs to be applied. SAP application should be down in this case until recovery is complete.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.