Friday, March 23, 2012

HELP! restore database - left in loading state? PLEASE HELP!

Hi all-
I actually don't work in SQL Server administration but I am trying to restore a database. I am a developer. I deleted all the rows from one of the tables in a database and I need to get that particular table back. The people that actually do the restor
e for me tell me that the RESTORE part has completed, but now the database says "(loading)" and stays this way indefinitely! They are trying to restore the database to a temporary location on another server, so that we can then just take the ONE table th
at I need back and import it back over. No one seems to have any idea how to move beyond this "loading" state and access the tables. Does this sound familiar to anyone? Please help - this is production data!!!!!! Thanks so much!!!
Try:
restore database MyDB with recovery
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"KMZ_state" <KMZ_state@.discussions.microsoft.com> wrote in message
news:A9DCF94E-276C-4D74-BB22-D55FCD672461@.microsoft.com...
Hi all-
I actually don't work in SQL Server administration but I am trying to
restore a database. I am a developer. I deleted all the rows from one of
the tables in a database and I need to get that particular table back. The
people that actually do the restore for me tell me that the RESTORE part has
completed, but now the database says "(loading)" and stays this way
indefinitely! They are trying to restore the database to a temporary
location on another server, so that we can then just take the ONE table that
I need back and import it back over. No one seems to have any idea how to
move beyond this "loading" state and access the tables. Does this sound
familiar to anyone? Please help - this is production data!!!!!! Thanks
so much!!!
|||Try:
restore database MyDB with recovery
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"KMZ_state" <KMZ_state@.discussions.microsoft.com> wrote in message
news:A9DCF94E-276C-4D74-BB22-D55FCD672461@.microsoft.com...
Hi all-
I actually don't work in SQL Server administration but I am trying to
restore a database. I am a developer. I deleted all the rows from one of
the tables in a database and I need to get that particular table back. The
people that actually do the restore for me tell me that the RESTORE part has
completed, but now the database says "(loading)" and stays this way
indefinitely! They are trying to restore the database to a temporary
location on another server, so that we can then just take the ONE table that
I need back and import it back over. No one seems to have any idea how to
move beyond this "loading" state and access the tables. Does this sound
familiar to anyone? Please help - this is production data!!!!!! Thanks
so much!!!
sql

No comments:

Post a Comment