Wednesday, July 19, 2006
My mssql tip for the day: Create a database named 'aaaaa'
The aaaaa database: it covers for your mistakes
The database restore tool in Enterprise Manager selects the first database alphabetically as the one to restore over. If you forget to change that trouble ensues. Having a dummy database in place means you will never restore over anything important. Our A customer was not too pleased when he lost a days work; especially the second time it happened.
I can truthfully say, though, that it wasn't me! *phew*