I am in the unfortunate situation of having to do a database restoration.
My full backup was at 9.30pm (157MB) and there were incrmentatl backups at 11am and 3pm. The incremental backups are less than 30kb each. It is now 6pm.
When I restored the full backup WITH RECOVERY, it took less than a minute. But I could not apply the two transaction logs.
When I restored the full backup WITH NORECOVERY, it also took less than a minute to say it was successful, but then the database remained in the Restoring... state. It has been like that for the last 40 minutes. Task Manager shows almost no activity. Is this normal? Should I abort?