Yes we have installed both 32bit & 64 bit oracle client.

Yes we can ping the server successfully.

Yes tnsnames.ora path has been specified in the system variables.

I just wanted to know...

use job completes option which is used for both successful & failed jobs

Create a operator & then go to job properties->Notification->select email when job succeeds.

Try restarting SQL Server on secondary server & also see to it that u have proper permission on Backup & copy folders on Primary & DR servers.

Also choose the option...

No you wont face any issue it will be restored properly

If you are not logshipping through domain account then

1)you must create a same windows account on both primary & secondary server having same password

2)Run the sql server & sql...

this script will give u fragmentation of particular database

SELECT ps.database_id, ps.OBJECT_ID, ps.index_id, si.name, ps.avg_fragmentation_in_percent,

(SELECT distinct so.name FROM sys.objects so INNER JOIN sys.indexes ON so.object_id = si.object_id) ParentTable

FROM sys.dm_db_index_physical_stats (DB_ID(13), NULL,...

USE THIS COMMAND

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY('edition')

Check the backup is valid or not by the following command

---RESTORE VERIFYONLY from backup device

this command will make sure that ur backup is proper

1)select * into new_tablename from existing_tablename (this will create a new table with data same as in existing table)

2) insert into new_tablename select * from existing_tablename(this will work only if...

1)Whats loading state it can either be norecovery mode(where database is not accessible) or standby mode where database is in read only mode.

2)You can check your retention period on...

You have set the retention period of how many days on primary server.

If it is of 3 days then you don't need to do anything,it will automatically come in sync...

Go to sql server instance properties->Security->Login Auditing->Select Both failed and successful login.

This will be recorded in sql server log or u can view by running sp_readerrorlog/ xp_readerrorlog

There is nothing called incremental backup in sql server.

There are 3 types of backup

1)Full

2)Differential

c)Transaction Log

Syntax:Full

Backup database database_name to disk='Physical location' with stats=10

Syntax:Differential

Backup database database_name to disk='Physical location'...

You need to create an operator & alert for configuring alert job.so that you can recieve a mail when your log shipping will get out of sync.

for more clarification please...