| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-28 : 08:45:05
|
| Sumit writes "Dear Sir,First i give my breif intro that i m a developer working in IT Industry. We have to maintaine tables in our database around 5 to 6 lacs record per table. If accodently any table deleted than what is the correct syntax through Query Analizer to retrieve table back.... This is very urgenti repeat through Query Analizer....(Correct Syntax)waiting for ur mail....RegardsSumit" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-05-28 : 08:55:01
|
| AFAIK therez no such command to get back a deleted table.yeah , if you have a backup of the db before deleting it . you can restore the table from there.or you can install Log exploerer from lumigent.com , there might be ways of getting it back, though am not sure on this.-------------------------------------------------------------- |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-05-28 : 19:24:49
|
| WHAT??????You mean SQL Server doesn't have a recycle bin ???OooopsDamian |
|
|
|
aiken
Aged Yak Warrior
525 Posts |
Posted - 2002-05-28 : 21:34:26
|
DROP DATABASE... Nah, I'm not that mean. Really, the correct syntax is:RESTORE DATABASE RestoreDB... ...there are a lot of options depending on whether you do differential backups, and whether the backups are stored to disk or tape. Look up RESTORE in the books on line. You probably want to restore to a new database, then use a query or DTS to just transfer that one table back to the original database.You do have a backup, don't you?Cheers-b |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-05-29 : 06:30:55
|
| If you catch it in time and you don't have any backups (if not - why not) then the newer versions of Log Explorer (>2.0) have the ability to restore dropped tables and truncated tables and it works really well - the caveat being that the data still needs to be in the log.In those situations it has worked really well.HTHJasper Smith |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-05-29 : 07:54:11
|
| Was the table dropped, or just the data deleted ? Maybe a recover to point in time will suffice if all that happened was a delete of data. |
|
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-05-29 : 08:12:28
|
| Has anybody else used NetApp's virtual disk for recovery? I've tested it on a 2GB filer and have been greatly impressed. I 'restored' a 120GB database in less than 3 minutes on a 10/100 (they required a GB Nic) and was also able to attach a 'snapshot' of the database for recovery of individual items within minutes as well. It's not cheap, but for redundancy it was really impressive. I'm trying to get one in for test data as the original filer we had has now been dedicated to Exchange. Just wondering. JamesH. |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-06-04 : 07:20:41
|
| You restored 120 gb over 100 megabit in 3 minutes ?100 mbits = +-12.5 MB/s = 750 MB/minute = 2.25 GB in 3 minutes ...Is my math way off, or are they doing something very different here ?When you say you "restored" I take it that they are doing something interesting like changes changed pages, as opposed to do proper restores... Were you able to do this while the DB was online (was SQL server running ?) Sounds interesting in any event... |
|
|
|
|
Retrieve Deleted Table