| Author |
 Topic  |
|
|
AskSQLTeam
Ask SQLTeam Question
USA
0 Posts |
 Posted - 10/10/2006 : 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
Sweden
29138 Posts |
Posted - 10/10/2006 : 07:41:59
|
Restore your backup of deleted database and the copy the data.
Peter Larsson
Helsingborg, Sweden |
 |
|
|
mr_mist
Grunnio
United Kingdom
1870 Posts |
Posted - 10/10/2006 : 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
Sweden
29138 Posts |
Posted - 10/10/2006 : 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 |
Edited by - SwePeso on 10/10/2006 10:03:26 |
|
|
|
madhivanan
Premature Yak Congratulator
India
22461 Posts |
Posted - 10/10/2006 : 09:51:12
|
Before dropping a database make sure to take Backup
Madhivanan
Failing to plan is Planning to fail |
|
|
|
eyechart
Flowing Fount of Yak Knowledge
USA
3575 Posts |
Posted - 10/10/2006 : 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)
USA
6997 Posts |
Posted - 10/10/2006 : 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 |
|
|
| |
Topic |
|
Retrieve table from deleted database
