April 29, 2004 at 9:03 am
I have a sql server 7.0 database.
every night a job execute in order to restore
this database. Last night something happened with the restore that the database kept the loading status. I haven't been able to restore it
nor to suppress the loading status
thanks in advance for any idea on this issue.
April 30, 2004 at 2:29 am
you need to do RESTORE DATABASE [DatabaseName] WITH RECOVERY.
Something has happened to the database which says it hasn't recovered yet just like if you did RESTORE DATABASE [DatabaseName] WITH NORECOVERY.
The with recovery clause should sort it out
Rich
January 6, 2005 at 11:08 pm
Hi,
I am new to MS SQL 2000.
I am learning about backup and restore. I am testing various restore methods on the Northwind database. I have changed the northwind database to full recovery mode. Make a full backup of it and backup transaction logs every 5 mins. I then generate several transactions on the database after the full backup.
I tried to perform point in time recovery of the northwind database(from Enterprise manager) and i got the same 'loading' status problem after EM restored the db. If i just restore the db from backup then the db is fine.
How do i resolve the point in time recovery issue?
I am SQLSERVER 2000 developer edition on my XP Prof. Laptop.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply