• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

deleting huge database

 
deepak carter
Ranch Hand
Posts: 165
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

My Application requires deleteing of a databse for about zise of 2 TB.can you tell me any secure way of that means to delete the database permantly from SQL SERVER 2000.

Thanks in advance.

 
Ulf Dittmer
Rancher
Posts: 42969
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Not sure if you can delete a DB via JDBC -that would in any case be dependent on which DB server you're using- but you can drop all individual tables via DROP TABLE XYZ (and you can get the names of all tables from a DatabaseMetaData object).
 
Paul Clapham
Sheriff
Posts: 21551
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When you say "secure", what kind of security exposures were you imagining?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35269
383
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
By secure, do you mean so the data is gone? Dropping the tables deletes from the database, but the data still exists on disk until it is overridden. Which is very difficult without destroying the hard drive.
 
Fatih Keles
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Just curious, what kind of application requires dropping a database of 2TB? To what purpose does it serve?

 
deepak carter
Ranch Hand
Posts: 165
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The application is getting decommission means its moving to .net with new database and evrything new so what wants to drop the databse
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35269
383
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If it is for a one time database migration, you can run the commands to delete the database from the database command line instead of using JDBC.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic