>I check and all of you are correct. The data is preserved after the re-creation. Funny, none of the documentation I found attempt to clarify that point. The statement on the checkbox led me to beleive it would not preserve the data.
>
The option may be a bit confusing, but from the common sense, why would SQL Server dump data? This will be considered a major bug then.
If it's not broken, fix it until it is.
My Blog