RE: 2005 Restoring



Wow, that's just impressive. OK, a 12MB Db should restore in just a few
secs, so you're several hundred thousand times off track...

That said, it looks like your restore is stuck somewhere. Are you restoring
the DB from the same version of SQL2k5?

ok, let's start here... answer these questions.

1. Are you restoring over an existing DB or has the original DB been
deleted and you're trying to get it back?

2. Is it restoring to the same server?

3. What is the exact syntax you're typing to run the restore?
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant – http://dbarant.blogspot.com




"Scott" wrote:

First be patient - I'm an Informix DBA who is tasked to manage a 2005
install. I have a db that's been restoring for 24 hrs and is only 12
MB. Normally it would only take a minutes and it would be done. I've
gone through the logs and found a few errors but nothing to do with
the db in question or the master.

Does anyone have any suggestion on how I can stop this? I can see the
process running but nothing that would indicate anything out of the
norm.

Thanks in advance.

.



Relevant Pages

  • Re: Windows mail not receiving attachments or displaying HTML mess
    ... I tried restoring to a few days ago, ... I did not have a time to install Outlook yesterday night, ... Windows Live Mail and imported the WM folders the free space was ... are displaying as plain text and come without attachments. ...
    (microsoft.public.windows.vista.mail)
  • Re: taskbar locked out and inaccessible for second user
    ... Not that I'm aware of - I'm not sure what one of those might be but I tend not to tinker with my system and install anything other than mainstream applications/utilities - to avoid getting into trouble and not having the knowledge to resolve problems. ... I am at a loss to pinpoint any activity on the computer that could have caused the change to occur - especially as restoring doesn't solve it. ... The first user to log on to the system can still work normally; when a second user logs on this second user will see their usual desktop - but will have no access to any part of their taskbar. ... The situation is the same whichever family member is the first user while any subsequent user will encounter the problem. ...
    (microsoft.public.windowsxp.general)
  • Re: Dual boot help please (Doing it right?).
    ... The back up is the O.S. with windows updates, ... restoring the back up takes a max 1\2 hour. ... restoring archives can ... install your third party software ...
    (microsoft.public.windowsxp.help_and_support)
  • 2005 Restoring
    ... First be patient - I'm an Informix DBA who is tasked to manage a 2005 ... install. ... I have a db that's been restoring for 24 hrs and is only 12 ...
    (microsoft.public.sqlserver.connect)
  • Re: How much to charge...
    ... their computer and install a firewall on it. ... they might be better off restoring the system from the recovery cd and ... I'll restore from the recovery media. ... virus, malware programs, and firewall before returning it to them. ...
    (microsoft.public.windowsxp.general)

Loading