![]() the shrinkfile routine to reduce your ldf file, the re-index patch also does something funny i think. Plus some routines in SIMS will break the integrity, e.g. If you want more you can do them more frequently, or look at backing up transaction logs, but it's a bit overkill unless you know what you are doing and how to restore them. I've never been convinced by differential / incremental on a database file. The main thing to think about is how do you want to restore and what are you willing to lose. I wouldn't have one method to do Full, and then another system to do Incrementals. ![]() Just stick to one system, and save it to disk or other location, then back up that location with the other system so they don't clash. If you did corrupt the chain like that, you'd not be able to use the incrementals only the Full ones. You're lucky it's complaining and not going ahead with the incremental. Never have multiple backup systems running like that, we had once ages ago and it breaks the chain of integrity.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |