database restore

Hi,
I have a problem with db restore.
everytime I restore the full database( on newly created db) on this one
perticular server for this one backup, the database goes in loading stage
and does not come back.
Does any body know what is happening?
Sam
Make sure you specify the RECOVERY option for the restore command.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <samirsoni@.hotmail.com> wrote in message news:%23XTHLkqHFHA.2648@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have a problem with db restore.
> everytime I restore the full database( on newly created db) on this one perticular server for this
> one backup, the database goes in loading stage and does not come back.
> Does any body know what is happening?
> Sam
>

database restore

Hi,
I have a problem with db restore.
everytime I restore the full database( on newly created db) on this one
perticular server for this one backup, the database goes in loading stage
and does not come back.
Does any body know what is happening?
SamMake sure you specify the RECOVERY option for the restore command.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <samirsoni@.hotmail.com> wrote in message news:%23XTHLkqHFHA.2648@.TK2MSFTNGP14.phx.gbl.
.
> Hi,
> I have a problem with db restore.
> everytime I restore the full database( on newly created db) on this one pe
rticular server for this
> one backup, the database goes in loading stage and does not come back.
> Does any body know what is happening?
> Sam
>