DB (loading) after master restore | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DB (loading) after master restore

Hi
After master and msdb restore i am able to restore databases but after refresj
db look like this:
db_name (Loading)
I looked at sa login.It can see only system databases.it doesn’t even have public access to user dbs.
Can someone help me with that?
Sorry: i tried to restore dbs with norecovery instead of recovery option
you used NORECOVERY that means you have to restore transaction logs If any.
If you think you don’t have any transaction logs then you can simply
run this command "RESTORE DATABASE YourDBNAME WITH RECOVERY" and restore will complete. -Nilay
]]>