I performed last night :-

SSMS-->Database-->task-->shrink-->file-->log-->release usused space and mentioned 10gb to be final size.

It went from 85GB to just 78GB...

What more could I do to get the size down?

Moreover, my...

@ azad...

r u running ur log shipping 24 hours??

u can skip for 5-6 hours everyday and during that time you can run this reindexing job..

Mine works like this only and...

what is the diff between these two :-

Backup log dbname with truncate_only

and

DBCC SHRINKFILE(dbname_Log, 8192)

??

Regards,

Sushant

I am not performing any log shipping in the night.

Just i have a full backup in night.

Regards,

Sushant

@ bhuvnesh

i cant get you what you mean to say?

What preventive measures I can take, before shrinking the log files on prod server?

Regards,

Sushant

@ gila

Is there a way of shrinking the database just on secondary(log shipping server) ??

Before doing any shrinking on prod server, if I backup the database, then is this fool...

@ gila....

Thanks...

On the log shipping server, to free the disk space, if i shrink the log files on the prod server,

then automatically log files on log shipping server will get...

@ gila

So, that means you want to say that i can do shrinking but again whenever I perform the index rebuilds, the log file will again increase and then again...

@ gila...

thanks.

Also, i have log shipping effective for those databases.

This morning, the log shipping was not in sync and I had to reconfigure the log shipping for that database (whose...

@ matt

You can delete old backup files on a daily basis too

delete files older than 1 day

by selecting tht option in the step" maintenance cleanup task"

Regards,

Sushant

before SP3 ,there would be many errors , working on maintenance plans.

Regards,

Sushant

I saw same errors in Windows event log and also 2 different errors:-

1. Windows saved user domain name\username registry while an application or service was still using the registry during...

@ sudha

It happens sometimes that the backup is done but it is not verified to be consistent and so as a whole; job is success but it doesnt have any...

@ sudha...

check if you have enabled the option verify backup once finished

Regards,

Sushant

@ steve

Yes, iam rebuilding all my indexes

Regards,

Sushant