The entire development database Dev_v1 was overwritten while I try to recreate all the objects in the new database Dev_v1_test using the Management Studio generated scripts (Generate Scripts for Database Objects from the Dev_v1 database).
Some detailed information listed here under:
1. I was the owner of the database Dev_v1_test. But my default database was Dev_v1. But some times, when I try to open the Dev_v1_test, it showed the database was not accessible.
2. In the scripts, I already add the following statement at the first line (and removed the old one)
3. The database version is SQL Server 2008R2.
I created all object in the Dev_v1_test database. Why it could overwrite the old database? It 's a bug?
View Complete Post