Retrieve table from deleted database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Retrieve table from deleted database

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-10-10 : 07:33:05

Gazza writes "Hi folks,
I have been studying SQL 2000 for three months now and making some progress towards my MCDBA,although in my haste I have deleted a database in error.
Please can you explain how I can restore a table from the deleted database into another database,I've tried importing but have failed to date.
Your advice would be appreciated

regards

Gazza

PC operating System Windows xp home
SQL Server 2000 (Developer edition)"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-10 : 07:41:59

Restore your backup of deleted database and the copy the data.

Peter Larsson
Helsingborg, Sweden

mr_mist
Grunnio

1870 Posts

Posted - 2006-10-10 : 08:40:25

So you've deleted a database and now want to copy a table out of the database you've deleted?

You'll need a time machine.

-------
Moo. :)

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-10 : 08:46:44

If you used DROP DATABASE, the physical files can still be there on the drive. If so, just attach the database again.

Peter Larsson
Helsingborg, Sweden

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-10-10 : 09:51:12

Before dropping a database make sure to take Backup

Madhivanan

Failing to plan is Planning to fail

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-10-10 : 10:43:00

quote:
Originally posted by AskSQLTeam

Gazza writes "Hi folks,
I've tried importing but have failed to date.

does this mean you have a backup?

-ec

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-10-10 : 22:34:09

quote:
Originally posted by Peso

If you used DROP DATABASE, the physical files can still be there on the drive. If so, just attach the database again.

Peter Larsson
Helsingborg, Sweden

DROP DATABASE deletes the physical files.

From SQL Server 2000 books Online:
"DROP DATABASE
Removes one or more databases from Microsoft® SQL Server™. Removing a database deletes the database and the disk files used by the database."

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources