snippetsqlMinor
Create a new database in SQL Server 2008 R2, but it is not Blank
Viewed 0 times
newcreate2008sqlbutblankdatabaseservernot
Problem
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
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?
.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?
Solution
New databases are cloned from database
model. Probably some accident polluted your model database (maybe a DDL script run in the wrong database). You should probably clean it up.Context
StackExchange Database Administrators Q#47993, answer score: 6
Revisions (0)
No revisions yet.