[SQL Server Data Warehousing] Script to drop and restore database in SQL

Hello Sathya

Thanks for your response. I have production databases and development databases. Sometimes for testing purpose, I need to use development databases and i want development database to have exact number of tables, data and logins.

So i restore prod database to dev database. which I do mannually. Now i want some scripts which i can put SQL job, so whenever I need to sync whole database, i can just run that job or automate job periodically.

Thanks

.

social.technet.microsoft.com/Forums