KcV (11/30/2013)
Hi,i have 25 GB database backup file. I just restored it with a different database name. after starting restoring process it took hardly 20-30 minutes to complete the process successfully.
but even after 20 hrs, sql server management studio shows :
Database
abc
def (Restoring ...)
why this 'restoring... ' is been showing even after complition of restore process. ?
Did you try right clicking on it and selecting "Refresh"? The Explorer window is rather famous for not automatically updating.
--Jeff Moden
Change is inevitable... Change for the better is not.