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
Robin
Hi,
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
>

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
>

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
>

Cannot restore a copy of SQL2000 to SQL2005

I ran into a weird problem trying to restore a backup copy of SQL2000
database into the new SQL2005 server. I copied the backup file
"databasename.bak" to the backup folder of the new SQL2005 server but cannot
see it using browse in restore function.
help!!!
BillI would say that was not exactly the same directory or there is a
permissions issue. Verify the complete path or try some other location.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Bill Nguyen" wrote:

> I ran into a weird problem trying to restore a backup copy of SQL2000
> database into the new SQL2005 server. I copied the backup file
> "databasename.bak" to the backup folder of the new SQL2005 server but cann
ot
> see it using browse in restore function.
> help!!!
> Bill
>
>|||Ben;
You're correct. I looked into the wrong folder.
After that, I ran into a different problem though:
I upgraded the SQLserver 2005 to SP1 ans tried to restore a copy of SQL2000
from another server to it. SQL 05 refused to restore saying that the backup
is for another SQLserver instance! I don't remember running into this
problem last time I did the same task.
Any idea why?
Thanks again.
Bill
Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:B1063714-ACF3-461D-885C-FCE372E210D4@.microsoft.com...[vbcol=seagreen]
> I would say that was not exactly the same directory or there is a
> permissions issue. Verify the complete path or try some other location.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Bill Nguyen" wrote:
>

Cannot restore

I have backed up a database created a .bak.
Now I created another database with other name. Then tried to restore the
.bak file into this new database.
However, I got an error:
"The backup set int file 'D:\Temp\Employee.bak' was created by BACKUP
DATABASE...FILE=<name>
and cannot be used for this restore operation.
RESTORE DATABASE is terminating abnormally.
Any idea?Alan
How many files the .BAK file is contain?
Check out 'WITH MOVE...' command in the BOL
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%235AfdvxoGHA.4996@.TK2MSFTNGP05.phx.gbl...
>I have backed up a database created a .bak.
> Now I created another database with other name. Then tried to restore the
> .bak file into this new database.
> However, I got an error:
> "The backup set int file 'D:\Temp\Employee.bak' was created by BACKUP
> DATABASE...FILE=<name>
> and cannot be used for this restore operation.
> RESTORE DATABASE is terminating abnormally.
> Any idea?
>|||Sorry, what do you mean by "How many files the .BAK file is contain" ?
I tried to restore in EM and got the error.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OYsjJ1yoGHA.524@.TK2MSFTNGP05.phx.gbl...
> Alan
> How many files the .BAK file is contain?
> Check out 'WITH MOVE...' command in the BOL
>
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%235AfdvxoGHA.4996@.TK2MSFTNGP05.phx.gbl...
>>I have backed up a database created a .bak.
>> Now I created another database with other name. Then tried to restore the
>> .bak file into this new database.
>> However, I got an error:
>> "The backup set int file 'D:\Temp\Employee.bak' was created by BACKUP
>> DATABASE...FILE=<name>
>> and cannot be used for this restore operation.
>> RESTORE DATABASE is terminating abnormally.
>> Any idea?
>|||Alan T wrote:
> Sorry, what do you mean by "How many files the .BAK file is contain" ?
> I tried to restore in EM and got the error.
>
You might have to use the REPLACE option if you want to overwrite an
existing database and use WITH MOVE if the files has to be moved to
another location. Try looking up RESTORE DATABASE in Books On Line. Here
you can find the syntax.
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator

Cannot restore

I have backed up a database created a .bak.
Now I created another database with other name. Then tried to restore the
.bak file into this new database.
However, I got an error:
"The backup set int file 'D:\Temp\Employee.bak' was created by BACKUP
DATABASE...FILE=<name>
and cannot be used for this restore operation.
RESTORE DATABASE is terminating abnormally.
Any idea?Alan
How many files the .BAK file is contain?
Check out 'WITH MOVE...' command in the BOL
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%235AfdvxoGHA.4996@.TK2MSFTNGP05.phx.gbl...
>I have backed up a database created a .bak.
> Now I created another database with other name. Then tried to restore the
> .bak file into this new database.
> However, I got an error:
> "The backup set int file 'D:\Temp\Employee.bak' was created by BACKUP
> DATABASE...FILE=<name>
> and cannot be used for this restore operation.
> RESTORE DATABASE is terminating abnormally.
> Any idea?
>|||Sorry, what do you mean by "How many files the .BAK file is contain" ?
I tried to restore in EM and got the error.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OYsjJ1yoGHA.524@.TK2MSFTNGP05.phx.gbl...
> Alan
> How many files the .BAK file is contain?
> Check out 'WITH MOVE...' command in the BOL
>
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%235AfdvxoGHA.4996@.TK2MSFTNGP05.phx.gbl...
>|||Alan T wrote:
> Sorry, what do you mean by "How many files the .BAK file is contain" ?
> I tried to restore in EM and got the error.
>
You might have to use the REPLACE option if you want to overwrite an
existing database and use WITH MOVE if the files has to be moved to
another location. Try looking up RESTORE DATABASE in Books On Line. Here
you can find the syntax.
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator