Cannot restore DB for SQL server

Hi
Can anyone help me. I'm using SQL Enterprise 8.0. I'd created a database
called temp. I want to restore data from backup.BAK. There are a few
problems I faced.
1. After I'd restore the database successfully, the temp database indicates
it is loading. There is no items when I expand the database. It is in the
middle of restoring. However, the restoring process is never ending.
2. I tried to restore the database and check 'Force restore over existing
database'. It displays an error as below
Microsoft SQL-DMO (ODBC SQLState:01000)
ConnectionRead (WrapperRead()).
General network error. Check your network documentation.
Processed 1 pages for database 'temp', file 'temp_log' on file1.
Thanks
RobinHi,
I recommend you to restore from Query Analyzer.
Say you have the backup file name as dbname_dump.bak in c:\backup folder.
Then issue the command:-
Restore database temp from Disk = 'c:\backup\dbname_dump.bak'
This will restore the backup file to TEMP database.
(You might need to use MOVE option incase ur restore commands prompts an
error ro Move, Look into books online for RESTORE database-- Move option)
Now regarding you questions:-
1. After I'd restore the database successfully, the temp database indicates
it is loading. There is no items when I expand the database. It is in the
middle of restoring. However, the restoring process is never ending.
Yes, it is in the middle of restore. This will also happen when you set
"Leave database nonoperational but abel to restore transaction logs".
If you click that then the after database restore it will go to
NORECOVERY mode and will be ready to load the subsequent transaction logs.
If you do not have transaction log you can execute the below command to
make database online or RECOVERY
RESTORE database temp with recovery
2. I tried to restore the database and check 'Force restore over existing
database'. It displays an error as below
Should not be an issue. Try from query analyzer as explained above
Thanks
Hari
MCDBA
"Robin" <wee789@.hotmail.com> wrote in message
news:ee9cSWhPEHA.2444@.TK2MSFTNGP12.phx.gbl...
> Hi
> Can anyone help me. I'm using SQL Enterprise 8.0. I'd created a database
> called temp. I want to restore data from backup.BAK. There are a few
> problems I faced.
> 1. After I'd restore the database successfully, the temp database
indicates
> it is loading. There is no items when I expand the database. It is in the
> middle of restoring. However, the restoring process is never ending.
> 2. I tried to restore the database and check 'Force restore over existing
> database'. It displays an error as below
> Microsoft SQL-DMO (ODBC SQLState:01000)
> ConnectionRead (WrapperRead()).
> General network error. Check your network documentation.
> Processed 1 pages for database 'temp', file 'temp_log' on file1.
>
> Thanks
> Robin
>