Post reply

frequent dropping of databases

  • January 18, 2011 at 4:34 am

    #232322

    Hi All,

    I am in the process of making a database build script. It creates the database, imports data into the tables and does other stuff. During the unit testing of my script, I frequently drop the databases from the Management Studio.

    I wanted to know whether frequent drop database causes anything adverse. Adverse can mean - tablespace getting exhausted, machine gets slower, something weird happening which I can't see etc.

    Regards.

  • January 18, 2011 at 4:39 am

    #1274591

    What is the size of your database?

    Abhijit - http://abhijitmore.wordpress.com

  • January 18, 2011 at 4:48 am

    #1274596

    Its not huge. It has around 100 tables but only around 9-10 have data.

    Regards.

  • January 18, 2011 at 4:58 am

    #1274607

    It clears the procedure cache. On a test server that shouldn't cause any problems.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply