When I try to create new database in SQL Server 2008 R2, it was created completely, but it is not a blank and empty database, there are many tables that come from another database. I also tried specifying a different name for its .mdf
and .ldf
file, but nothing changed!
Would you please help me to know where is the problem?
Also, is there any command that would reset my database as a blank db?
Best Answer
New databases are cloned from database
model
. Probably some accident polluted yourmodel
database (maybe a DDL script run in the wrong database). You should probably clean it up.