HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

Create a new database in SQL Server 2008 R2, but it is not Blank

Submitted by: @import:stackexchange-dba··
0
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 .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.