emptying database

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Phung

    emptying database

    Hi friend ! is there anyway to erase the whole content of a database
    other than executing the script.

  • Greg D. Moore \(Strider\)

    #2
    Re: emptying database

    "Phung" <purwa@purwadhi ka.comwrote in message
    news:1193056060 .280220.235250@ e9g2000prf.goog legroups.com...
    Hi friend ! is there anyway to erase the whole content of a database
    other than executing the script.
    >
    You could drop and recreate the DB.



    --
    Greg Moore
    SQL Server DBA Consulting Remote and Onsite available!
    Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html


    Comment

    • Jack Vamvas

      #3
      Re: emptying database

      If you are dropping and recreating , don't forget to take a script backup of
      the db

      --

      Jack Vamvas
      _______________ _______________ _____
      Search IT jobs from multiple sources- http://www.ITjobfeed.com




      "Phung" <purwa@purwadhi ka.comwrote in message
      news:1193056060 .280220.235250@ e9g2000prf.goog legroups.com...
      Hi friend ! is there anyway to erase the whole content of a database
      other than executing the script.
      >

      Comment

      Working...