also,

there has not been any reorganize/rebuild indexes on this database for 2-3 months.

Regards,

Sushant

@ homebrew

Are there script for running index rebuilds for some defined percentage of tables in a database...

for ex 25% of database tables at a time.

As my db has 2000 indexes,...

Ya..there was a misunderstanding because:_

The original poster wrote "can we setup LS more than 1 db at a time"

setup is the configuring part, whcih we cant do more than 1...

I know what you are saying but for example I have 8 databases and I want to LS all at a time

is it possible?

I think we have to configure...

Is it possible when running the script for rebuilding indexes , that I can shrink the log files in between.

If so, how?

Regards,

Sushant

They can be done simultanouesly one after another but not all at a single time.

Regards,

Sushant

in 3) I meant if i run the script ..

You can create another column as diff between the 2 column values.

In the where clause, you can spcify another condition, name of the new column > the value.

Regards,

Sushant

DBA

West Indies

@ tertiusdp

Thanks, it worked correctly now.

Thanks everyone for helping me .

Regards,

Sushant

DBA

West Indies

I wrote a diff procedure to pass values in the above proc

Declare @Month int,

@Year int

Set @Month = DatePart(mm,Getdate()) -1

if @Month =...

can you check if the auto_close_on ( db options) is enabled?

Regards,

Sushant

@ SQL_Quest

Thanks, it worked.

I had some stale data in the log shipping monitor tables on primary side.

I deleted it and all log shipping was back in sync.

Thanks all of...

you changed the timeout setting on whcih server- source or the destination?

Regards,

Sushant

how are you importing the data?

using SSIS or what?

Hi,

I was able to successfully restore the database on secondary side and also set up log shipping.

But there was a variance.

As far as I know, log shipping...