Chat now with support

Live-Hilfe anfordern
Registrierung abschließen

Anmelden

Preisinformationen anfragen

Vertrieb kontaktieren

Kostenlose Testversionen

Can you include a re-index with a LogShipping plan? (4323767)

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

Can you include a re-index with a LogShipping plan?
Beschreibung

Can you include a re-index with a LogShipping plan?
Lösung

There is no way to reindex without breaking Litespeed logshipping.
Weitere Informationen

Best practice for doing DB maintenance for databases used in Log Shipping:
Setting to simple mode will break the log chain, so that is out for LogShipping. Development suggest to maintain the database to whatever degree it requires and ignore the fact it is log shipping, just take more frequent tran log backups during index rebuilds\reorgs. One thing you can do is run integrity checks (checkdbs) on the secondary database to take some load off the live database

But at the same time you may find you need to change Full recovery model to Simple because reindex on a database with TB of data in a Full recovery mode will enlarge the transaction log dramatically.

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Request a KB Article

Leave a Comment

Empfohlener Inhalt

Produkt(e):: LiteSpeed for SQL Server

Thema/Themen:: Technical Solutions

Artikelhistorie:: Erstellt am: 9/2/2010
Letzte Aktualisierung am: 5/7/2023

Alle Artikel durchsuchen