I had to recover from a point in time with this script...
RESTORE LOG IT_DATABASE FROM
DISK=N'\\sqlserver\E$\SQLSERVER_BACKUPS\IT_DATABAS E.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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment