cancel
Showing results for 
Search instead for 
Did you mean: 

How to apply transaction logs to a standby DB?

Former Member
0 Kudos

We already moved the logs to the standby server.

Please advise us how to use the GUI to apply them? Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hope you are using SQL Server Management Studio (SSMS)

Open SSMS Right click on the Databases in the left hand side and click on the "Restore Files and Filegroups...".

In the "Specify the sources and location of backup sets to restore" select "From Device"....in the next screen Add the T-Logs which you want to restore.

Do the restore.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Please tell me what SQL Server version are you using.

Regards,

Clint

Former Member
0 Kudos

Hi,

what is your goal? more details please!