July 5, 2004 at 10:43 pm
SQL Server 2000 supports a new feature that allows users to insert a named transaction in the transaction log and allow recovery to that point, similar to point-in-time recovery as implemented in SQL Server 7.0. In addition, these marks are tracked in the msdb database, enabling users to determine what marks are available and plan recovery accordingly.
To get the database out of loading status (without restoring another transaction log backup), run the following statement:
RESTORE DATABASE DatabaseName WITH RECOVERY
May be this will sort the problems.
July 5, 2004 at 11:04 pm
Many thanks - will try that when I get a chance.
Phil
September 21, 2004 at 1:59 pm
No. This does not work. I am having the same problem
RESTORE DATABASE DatabaseName WITH RECOVERY
It is giving an error message that database was partially restored.
Any help will be greatly appreciated.
September 22, 2004 at 5:17 am
We had a problem with restores not working for large databases when we first moved to SQL 2000. The restores were run on a standby server but were initiated from a job running on the production server. We tracked down the problem to the fact that remote query timeout is set to 600 seconds at SQL 2000 but there isn't a timeout at SQL 7. Changing the timeout to 0 fixed the problem. Check server properties on the connections tab.
September 22, 2004 at 7:26 am
Thanks. I have timeout at 0. Any other suggestion.
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply