when i m trying to execute with actual execution plan it is taking more than 8 mins and getting hung :(. I have no clue what is going on.

One of the source tables have Clusterd index and other table has 1 Unique,Non-clustered and 12 Non-Unique, Clustered indexes. I tried using the estimated execution plan which suggested me for...

Hi,

U can take a weekly full backup and also choose for hourly (once in four hours) differential backups and schedule transaction logs for less interval of time for point-in time.

Its...

Can u tell what does the copy job history say?

what is the error message?

Hi,

Is it service accounts or few users?

If its service accounts, y would u provide passwords of the service account to the users (Security risk).

If it's users (in multiple numbers)...

Yes

Check if there is any data transfer latency. It would specify in the LS configuration.

Any netbackup going on behind the scene? U can check on your system tray.

Did u create an alert as well and checked the option e-mail to the operator DBA ?

You can create a trigger too, to prevent from having these kind of changes in the near future.

You are releasing space to the OS from tempdb, which might get ur indexes rebuild little faster than usual when you are doing online.

Are there any activities that go around during the time of index rebuild? Try scheduling this activity without interfering any other jobs or schedules.

Try shrinking the tempdb database prior to...

Hi,

Did u do the following steps

1: Create a Shared folder/directory on both the servers.

2: The Agent Service account of the secondary server should have read/write access to the shared folder...

Hi,

The litespeed generates the naming convention for its trn files by default which cannot be modified. I did give a try when i was working before with the litespeed logshipping...