I have restored a 1TB database and now it shows the restore completed 100% but the database is not accessible.
sp_who2 has a SPID 50 performing this restore but current command its showing is
'CREATE INDEX' and this SPID is not completing from quite long time.
When I verified through
sp_whoisactive this spid is trying to create index on a table of 12gb size but the % complete shows as 100%...
Now for 2 hours the DB has not been accessible and this spid is not finishing. Main thing to note is this restore happens daily and used to work fine from ages.
Any help ides would be much appreciated. I already tried taking SQL Server services offline and removed the underlying db files and start fresh restore but still it got stuck in same way....