Log Shipping Configuration SQL Server

Setting up Log Shipping:

For Details : http://msdn.microsoft.com/en-us/library/ms188698.aspx

DB (Right Click)-> Task->Log Shipping->Select Server -> add path for the folder (must have write permission to the user assigned to the SQL services)

Configure the Frequency of Log Shipping.
Click OK. 

Restoring DB from no recovery (Log Shipping) mode to active mode:

Select database and run this command in Query browser:

RESTORE DATABASE CPSDB WITH RECOVERY

Adding / Retrieving new Certificate from LDAP into WAS

SSL certificate and key management > Key stores and certificates > NodeDefaultTrustStore > Signer certificates > Retrieve from port

port 636

Note: NodeDefaultTrustStore can be different according to the environment.
If it is cluster then it will be CellDefaultTrustStore

Clearing transaction logs in SQL Server

Select Database
Open Query Writer
Execute following commands:

backup log <dbname> with truncate_only
go
DBCC SHRINKDATABASE ( <dbname>, 10, TRUNCATEONLY)
go

SVN Client configuration

download  tortoise SVN client : tortoiseSVN-1.6.16 (or latest one)

Install it and restart windows
create a folder in C:
right click on that folder
select SVNTortoise > Repo Browser

Enter Repository URL

Enter user id and password
Check remember / accept permanently

Close it

Right click inside the folder
Click checkout
Select Trunk (Main folder)
Click head revision
Click OK


This will download the main repository folder to your harddisk.