Andrzej Sulej (2/18/2011)

---

You can set up state of database after restoring log in LS , if you would like to have read only database , then you use standby...

paul.knibbs (2/18/2011)

---

Yes, it *can* get back into sync automatically. The only reason it would not do that is if one of the log file backups was lost. Once that big...

Dude, thts a very wide topic...

See this :-

http://www.sqlservercentral.com/Forums/Topic1064918-146-1.aspx

Regards,

Sushant

Do you think that once it gets out...

Andrzej Sulej (2/18/2011)

---

In what state you leave database after restoring log - standby or no recovery?

If you have standby, change to no recovery,that will speed up process of restoring logs,...

paul.knibbs (2/18/2011)

---

When you say your log shipping is going out of sync, how long are you leaving it for? We have log shipping set up over an ADSL link (e.g....

Wats this ??

v run daily full db backup at around 8:30 pm of tht particular db. The db is 320 gb and it takes around 1.5 hrs to backup.

What would happen if...

We run log shipping everyday from 6AM-8PM , with 5 minutes interval on prod database.

We do rebuilding indexes every 2 weeks on a weekend, so i cant change the course...

If i do the rebuild of only some indexes and that too some specific nights and then also the log file is around 25 gb, then will it go again...

CirquedeSQLeil (2/16/2011)

---

A couple of things you could do to minimize the log size and the effect on logshipping.

Change your rebuild job so that it only rebuilds specific tables on certain...

dude thanks

but thts a whole book to read 🙁

I wish i had tht muc time 🙂

Anyways, thxs

I appreciate ur help

Regards,

Sushant

RonKyle (2/16/2011)

---

The month should already exist as a seperate column that has already been created on the underlying table. You then would take that information and turn it into...

@ grant

Urs book on sql server exceution plans is meant for sql 2005 or 2008 or is it just a general book.

Regards,

Sushant

how u can take the log backups wen hte recovery mode is simple??? I cant get tht

Moreover for full recovery, it all depends upon the changes on the db and...