DB in "loading" state

  • I restored a database and by mistake told SQL Server that I will be loading more logs. Now the database is in loading state. How can I change that and bring the database online? Thanks in advance for your help.

  • RESTORE DATABASE <Database> with recovery

    This will do it.

  • Thank you!!!!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply