Home Forums SQL Server 7,2000 Backups Restoring an SQLServer 2000 database - questions... RE: Restoring an SQLServer 2000 database - questions...

  • First, that's NOT a large database. I've restored a 200+ GB database (yes, that's GIGABYTE).

    Next, how did you do the restore? Can you post your script?

    It looks like you may have used WITH NORECOVERY which will leave the database in LOADING state awaiting other backup files.

    WITH NORECOVERY is used when you have to also restore a differetial or one or more transaction logs.

    If you used WITH NORECOVERY, you could just run:

    RESTORE DATABASE emweb WITH RECOVERY

    -SQLBill