<div>
After you restored the last backup, did you mark the flag to MOUNT it? It could be expecting further transaction log restores if you didn't
</div>


After you restored the last backup, did you mark the flag to MOUNT it? It could be expecting further transaction log restores if you didn't

<div>
thanks for all the help VMontalvao. I would have known if it said recovering.
</div>


thanks for all the help VMontalvao. I would have known if it said recovering.

<div>
<div class="content wysiwyg-content">
i restored a database from a backup and logs following it. its sql 2000 and its for log shipping secondary server. so i used norecovery for all. now it shows 'loading' next to the database and i cant right click and find properties or i cant get any help from sp_helpdb. i hope there is no error in my restore. is loading the same as restoring in sql 2005? did i do it right?
</div>
</div>


i restored a database from a backup and logs following it. its sql 2000 and its for log shipping secondary server. so i used norecovery for all. now it shows 'loading' next to the database and i cant right click and find properties or i cant get any help from sp_helpdb. i hope there is no error in my restore. is loading the same as restoring in sql 2005? did i do it right?

sql 2000 database loading

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.