Re: Transaction log files in a SE database

> I couldn't help but add my two pennorth to sally's excellent comments. > > There is one thing which most users forget about SE. Any schema change > entails - > > 1. Back up the database > 2. Restart logging > > SE does not log schema changes so if a new transaction involves a > slightly different table layout, a different index perhaps But I'm not > too surer, than you can't roll it forward. Bugger! I need to test that! I knew you couldn't rollback but... ------------------------------------------------------------------- These are *my* opinions. Please don't make the mistake of believing anybody else is stupid enough to think like this! ------------------------------------------------------------------- Stuart Hemming | shemminga@cix.compulink.co.uk The Data Base | Tel: + 44 (0) 115 925 0005 Nottingham UK | Fax: + 44 (0) 115 925 0951 -------------------------------------------------------------------