If you create a database, don’t expect it to live forever. Always keep a backup of at least your schema, and preferrably your data. After having experienced a total data loss, I’m at least reassured that I kept my schema on a system other than the one the database was running on. I had to recreate all my tables and indexes, but thankfully I’d saved them offline and it was as simple as cutting and pasting. Now, if only I had backed up my data…
Geek Tip of the Day
