Strange DB Statement after RESORE

[bborissov]

After restoring a Backup from our Application the BD stays in some strange state. Nothing could be done with it and the error message is "DB is still restoring (or something like this). Even with SSMS I only could drop DB, create a new one and then restore the backup.
The strangest thing is that this is happened only on one server and I have no clue where I should look.

Restore is executed from a SP and there are no errors returned from it.

The executed command is:

RESTORE DATABASE @BASE_NAME 
        FROM  DISK = @FILE_NAME
              WITH  FILE = 1,
              MOVE @LOGICAL_NAME TO @TODB,
              NOUNLOAD, REPLACE

where all variables has the right values

SQL Server 2008 on Windows Server 2008 both are 64 bits.

TIA

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[SQLBill]

Are you restoring across a network? If so, did the connection drop during the restore?

Try running this: (replace dbname with the actual database name).

RESTORE DATABASE dbname
WITH RECOVERY

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[SQLBill]

One other thing, check the SQL Server Error Log to see if it gives any errors that are related. For example, is the drive out of space?

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[bborissov]

Thank you,
I thought also that the missing hint WITH RECOVERY is the reason.


Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.