Friday, February 17, 2012

DB IN LOADING STATE?

I had to recover from a point in time with this script...
RESTORE LOG IT_DATABASE FROM
DISK=N'\\sqlserver\E$\SQLSERVER_BACKUPS\IT_DATABASE.BAK'
WITH RECOVERY,STOPAT='03/02/2005 13:35:00'
Now my DB is in a loading state and don't know how to get
it back operational...Any help is greatly appreciated.
Thanks,Hi Bruce,
It looks like IT_DATABASE.BAK is not a transactional log backup file. You
need to use log backup file for point in time recovery.
Try issuing
RESTORE DATABASE YourDatabase
WITH RECOVERY
.....to recover from the loading state. Let us know, if the problem
persists.
--
Thanks
Yogish|||Try closing down the process running it then try again.
If that doesn't work detach then attach the database it
worked for me anyway ;)
Peter
"It's true hard work never killed anybody, but I figure,
why take the chance?"
Ronald Reagan
>--Original Message--
>I had to recover from a point in time with this script...
>RESTORE LOG IT_DATABASE FROM
>DISK=N'\\sqlserver\E$\SQLSERVER_BACKUPS\IT_DATABASE.BAK'
>WITH RECOVERY,STOPAT='03/02/2005 13:35:00'
>
>Now my DB is in a loading state and don't know how to get
>it back operational...Any help is greatly appreciated.
>Thanks,
>
>.
>

No comments:

Post a Comment