Recovery of a Table From SQL SERVER 2000

Unfortunately a table is Deleted by me from my database.

Now How I can Recover that

I have no data and structure of that table Now.

It Was Very IMP. Table .

So Plz Help.......

the only option that comes to my mind is to restore the latest backup which was taken before the table was deleted.....it will definitely contain the datas you need........but b4 that take a backup of your db now so that if required you can restore from this backup......thanx
|||

You 'may be able to recover the data from the log files (assuming you have a FULL recovery model in place) by using one of the third party Log exploration tools.

I suggest exploring Lumigent's Log Explorer, or ApexSQL's Log tools. I think that fully functional evaluation copies are available online.

|||

Restore your last backup to another server or another database name. You can use DTS or scripting to move the table and data to the database where you dropped the table.

-Sue

|||

Thanks Sir

Its work

But i want to Know Some Free Data Recovery tools.

Could U Send Some Link Of That Types of tools Sites.

Thanks

With Regards

Yogesh Kumar.

Software Consultant

New Delhi.

|||It's actually difficult to find one when you are looking for something "FREE." Third-party tools out thre have evaluation periods which you can try out

|||

The only "free" data recovery tool I can think of is SQL Server's native backup and restore.

-Sue

|||inaddition to what i said earlier if you have sql 2005 you can also make use of Database snapshot.It is a new feature available in sql 2005 enterprise edition...........if you had taken a snapshot before dropping some records you can retrieve those records by restoring from the snapshot....

Recovering a database

Our disk was corrupted and all we maneged to get was the mdf file of a
database (ldf file is lost).
Can I get at least the structure of a database from mdf file or everything
is lost?
regards,Ssimon
Did you do BACKUP of the database, didn't you?
Try to attach a .MDF file by using sp_attach_single_file_db but it might not
work because you did not detach the database firstly
This one I have just found on internet
-- Encountered a situation where the physical log files
-- for a database were deleted and as a result the
-- database was marked suspect.
-- This was the solution to overcoming that issue. The
-- databases in question successfully came back up on
-- line at the end of this.
select dbid, status, name
from sysdatabases
sp_configure 'allow updates', 1
go
reconfigure with override
go
-- puts in emergency repair mode
update sysdatabases
set status = 32768
where dbid = 8
go
-- stop and start sql server
dbcc rebuild_log ('database_name','physical_path_to_log_f
ile')
-- puts in single user mode
update sysdatabases
set status = 4096
where dbid = 8
-- stop and start sql server
use database_name
dbcc checkdb('database_name')
-- reset the status
update master..sysdatabases
set status = 0
where dbid = 8
sp_configure 'allow updates', 0
go
reconfigure with override
go
-- stop and start sql server
select dbid, status
from master..sysdatabases
"simon" <simon.zupan@.stud-moderna.si> wrote in message
news:uYVfCowpFHA.616@.TK2MSFTNGP15.phx.gbl...
> Our disk was corrupted and all we maneged to get was the mdf file of a
> database (ldf file is lost).
> Can I get at least the structure of a database from mdf file or everything
> is lost?
> regards,S
>|||<snip>
> This one I have just found on internet
<snip>
> dbcc rebuild_log ('database_name','physical_path_to_log_f
ile')
<snip>
I suggest you also warn about the downsides using this command. It doesn't c
heck for any type of
consistency. You can have half-finished transactions, missing rollbacks etc.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:%23GiWUswpFHA.3084@.TK2MSFTNGP09.phx.g
bl...
> simon
> Did you do BACKUP of the database, didn't you?
> Try to attach a .MDF file by using sp_attach_single_file_db but it might n
ot work because you did
> not detach the database firstly
>
> This one I have just found on internet
> -- Encountered a situation where the physical log files
> -- for a database were deleted and as a result the
> -- database was marked suspect.
> -- This was the solution to overcoming that issue. The
> -- databases in question successfully came back up on
> -- line at the end of this.
> select dbid, status, name
> from sysdatabases
> sp_configure 'allow updates', 1
> go
> reconfigure with override
> go
> -- puts in emergency repair mode
> update sysdatabases
> set status = 32768
> where dbid = 8
> go
> -- stop and start sql server
> dbcc rebuild_log ('database_name','physical_path_to_log_f
ile')
> -- puts in single user mode
> update sysdatabases
> set status = 4096
> where dbid = 8
> -- stop and start sql server
> use database_name
> dbcc checkdb('database_name')
> -- reset the status
> update master..sysdatabases
> set status = 0
> where dbid = 8
> sp_configure 'allow updates', 0
> go
> reconfigure with override
> go
> -- stop and start sql server
> select dbid, status
> from master..sysdatabases
>
> "simon" <simon.zupan@.stud-moderna.si> wrote in message
> news:uYVfCowpFHA.616@.TK2MSFTNGP15.phx.gbl...
>|||thanks for your answers.
How can I rebuild log if I don't have log file?
I have only mdb file.
regards,S
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OxEKCmxpFHA.4056@.TK2MSFTNGP10.phx.gbl...
> <snip>
> <snip>
> <snip>
> I suggest you also warn about the downsides using this command. It doesn't
> check for any type of consistency. You can have half-finished
> transactions, missing rollbacks etc.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23GiWUswpFHA.3084@.TK2MSFTNGP09.phx.gbl...
>|||there's no magic. If SQL Server has recovery work to perform, and you don't
have the ldf file, you
don't have the information needed to perform that recovery. Either live with
an inconsistent
database, or restore from a good backup. If you do decide to live with a pos
sibly inconsistent
database, I suggest opening a case with MS Support as they might have inform
ation that can be
relevant to you.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"simon" <simon.zupan@.stud-moderna.si> wrote in message news:Ob6plYypFHA.3568@.TK2MSFTNGP10.p
hx.gbl...
> thanks for your answers.
> How can I rebuild log if I don't have log file?
> I have only mdb file.
> regards,S
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:OxEKCmxpFHA.4056@.TK2MSFTNGP10.phx.gbl...
>

Recover structure from corrupt .MDF?

Hi,
I have a corrupt .mdf file and all I want to do is get the stored procedures
& table structure out of the file. Is this possible? (I do not have a
backup ).
cheers
James"James" <jamese@.dontspam.com> wrote in message
news:ONeoYLzeGHA.4976@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have a corrupt .mdf file and all I want to do is get the stored
> procedures & table structure out of the file. Is this possible? (I do not
> have a backup ).
That depends on the level of corruption. As long as the procedures weren't
encrypted, they are stored in the MDF file as text and may be fished out.
The tables are another story.|||You are a bl**dy star....I'm so stupid, I should have thought to open the
file as a text file. Thank you so much!!!
James
"BDB" <bdb@.reply.to.group.com> wrote in message
news:OnmhcV1eGHA.3900@.TK2MSFTNGP05.phx.gbl...
> "James" <jamese@.dontspam.com> wrote in message
> news:ONeoYLzeGHA.4976@.TK2MSFTNGP02.phx.gbl...
>> Hi,
>> I have a corrupt .mdf file and all I want to do is get the stored
>> procedures & table structure out of the file. Is this possible? (I do not
>> have a backup ).
> That depends on the level of corruption. As long as the procedures
> weren't encrypted, they are stored in the MDF file as text and may be
> fished out. The tables are another story.
>

Recover structure from corrupt .MDF?

Hi,
I have a corrupt .mdf file and all I want to do is get the stored procedures
& table structure out of the file. Is this possible? (I do not have a
backup ).
cheers
James"James" <jamese@.dontspam.com> wrote in message
news:ONeoYLzeGHA.4976@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have a corrupt .mdf file and all I want to do is get the stored
> procedures & table structure out of the file. Is this possible? (I do not
> have a backup ).
That depends on the level of corruption. As long as the procedures weren't
encrypted, they are stored in the MDF file as text and may be fished out.
The tables are another story.|||You are a bl**dy star....I'm so stupid, I should have thought to open the
file as a text file. Thank you so much!!!
James
"BDB" <bdb@.reply.to.group.com> wrote in message
news:OnmhcV1eGHA.3900@.TK2MSFTNGP05.phx.gbl...
> "James" <jamese@.dontspam.com> wrote in message
> news:ONeoYLzeGHA.4976@.TK2MSFTNGP02.phx.gbl...
> That depends on the level of corruption. As long as the procedures
> weren't encrypted, they are stored in the MDF file as text and may be
> fished out. The tables are another story.
>