Re: HELP!!! restore database - left in loading state?? PLEASE H

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: KMZ_state (KMZstate_at_discussions.microsoft.com)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 15:34:01 -0700

Tom!!!! Thank you! Thank you! Thank you! It worked and it only took a millisecond and all my tables are there. Now I just need to export these records back to my empty table in the production data. I really appreciate your help - I was at my wits end about this. You really saved my life with this. Thanks so much again...

"Tom Moreau" wrote:

> Any object names that contain special characters, such as a hyphen, need to
> be delimited by brackets:
>
> RESTORE DATABASE [DMA-SCRATCH] 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" <KMZstate@discussions.microsoft.com> wrote in message
> news:64C0DDC9-E033-4394-96D1-D097572C7C3E@microsoft.com...
> Hi-
> I just tried it:
>
> RESTORE DATABASE DMA-SCRATCH WITH RECOVERY
>
> and I get an error message: Incorrect syntax near '-'. The name of the
> database is DMA-scratch. Is the hyphen an illegal character? This could be
> the problem if it is. Thanks.
>
> "Tom Moreau" wrote:
>
> > Yep.
> >
> > --
> > Tom
> >
> > ---------------------------------------------------------------
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Columnist, SQL Server Professional
> > Toronto, ON Canada
> > www.pinnaclepublishing.com/sql
> >
> >
> > "KMZ_state" <KMZstate@discussions.microsoft.com> wrote in message
> > news:3198ACB9-7762-4640-8A07-B9E5D87BE63E@microsoft.com...
> > OK, so bear with me. I don't normally do this. So, in the Query Analyzer
> I
> > can just say RESTORE DATABASE TESTDB WITH RECOVERY, where TESTDB is the
> name
> > of the database that I have supposedly restored, but is still in this
> > loading state???
> >
> > "Tom Moreau" wrote:
> >
> > > You have to restore the database somewhere. I'm assuming that by virtue
> > of
> > > the fact that it is in a loading state, you have attempted to restore
> it.
> > > However, it appears to have been restored without recovery. Therefore,
> > you
> > > need to recover the database, which is what my code does for you.
> > >
> > > --
> > > Tom
> > >
> > > ---------------------------------------------------------------
> > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > > SQL Server MVP
> > > Columnist, SQL Server Professional
> > > Toronto, ON Canada
> > > www.pinnaclepublishing.com/sql
> > >
> > >
> > > "KMZ_state" <KMZstate@discussions.microsoft.com> wrote in message
> > > news:294EC3AF-340F-4C13-8689-BF61DA9D2DC9@microsoft.com...
> > > But what if I want to restore to a separate location, and not just blast
> > > away the database?
> > >
> > > "Tom Moreau" wrote:
> > >
> > > > 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!!!
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages