Transactional logs application

[Former Member]

Hi Experts,

I am planning to install new system by homogeneous
system copy. (Windows 2008 / MS SQL 2008 ) as below.

1. Take a full backup and log
   backup from system A.
2. Install Central Instance and
   database software on System B.
3. Create and attach database by
   database specific procedure [ Backup restore ] (Note 151603 )
4. Perform follow-up tasks on
   system B.

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?

1. ftp transaction log files from
   system A to System B.
2. Recover database using below
   commands.

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.

[Sriram2009 · Accepted solution]

Hi

System copy in windows with MS sql server you can perform two ways

1. Backup the db in system a and restore the same to system b
2. stop the sap instance detach the ms sql db in system a , then do the normal copy from system a to b. and finally in both system you do the attach and the start the sap instance in system a and the do the system copy as mention in the system copy guide
3. Ms Sql DB you can start the backup any time (Online backup)

Thanks

Sriram

[Former Member · Accepted solution]

Duplicate question. I am closing it.