Restoring from 7.0 to 2000 Enterprise Edition...

Hi,
I have read restore on BOL , but i am unable to restore a SQL 7.0 back
up to SQL Server 2000. I have tried things given in the following
article
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpt_15ro.asp
and i have also tried to restore the back up by using the following
procedure.
My database name is "Hello". I have first created a new database named
"Hello" by using Enterprise Manager and then i opened up Query Analyzer
and choose the database named 'Hello' from dropdown and wrote down the
following
Restore DATABASE HELLO
>From disk = 'd:\Documents and
Settings\Administrator\DEsktop\backup\Hello'
WITH Move 'Hello' to 'D:\test\Hello.mdf'
Go
But i get some errors as in "Exclusive access could not be obtained
because the datavase is in use' and 'Restore Database is terminating
abnormally.
Note: My SQL 7.0 back up stored in the location 'd:\Documents and
Settings\Administrator\DEsktop\backup\Hello'. I am using SQL Server
2000Enterprise Edition on Windows 2000 Advanced Server.
Please do reply me with what i ammissing. I have read quite a few
things on BOL and on MSDN. However, i am stumped. I would really
appreciate any help as im a newbie so please point me to the solution
or to any article / online-resource that would lead me to the solution.
Take care and looking forward.
Please do reply me what i am missing here.The problem is that you are selecting the Hello database in Query Analyzer
and then, when you run the restore command, the Hello database is already in
use.
Supposing that you want to replace the existing Hello database, select
another database in Query Analyzer, like master, and run the same command.
Ben Nevarez
"Erland" <Erland.Erikson@.gmail.com> wrote in message
news:1132539237.114914.201650@.o13g2000cwo.googlegroups.com...
> Hi,
> I have read restore on BOL , but i am unable to restore a SQL 7.0 back
> up to SQL Server 2000. I have tried things given in the following
> article
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpt_15ro.asp
> and i have also tried to restore the back up by using the following
> procedure.
> My database name is "Hello". I have first created a new database named
> "Hello" by using Enterprise Manager and then i opened up Query Analyzer
> and choose the database named 'Hello' from dropdown and wrote down the
> following
> Restore DATABASE HELLO
>>From disk = 'd:\Documents and
> Settings\Administrator\DEsktop\backup\Hello'
> WITH Move 'Hello' to 'D:\test\Hello.mdf'
> Go
> But i get some errors as in "Exclusive access could not be obtained
> because the datavase is in use' and 'Restore Database is terminating
> abnormally.
> Note: My SQL 7.0 back up stored in the location 'd:\Documents and
> Settings\Administrator\DEsktop\backup\Hello'. I am using SQL Server
> 2000Enterprise Edition on Windows 2000 Advanced Server.
> Please do reply me with what i ammissing. I have read quite a few
> things on BOL and on MSDN. However, i am stumped. I would really
> appreciate any help as im a newbie so please point me to the solution
> or to any article / online-resource that would lead me to the solution.
> Take care and looking forward.
> Please do reply me what i am missing here.
>|||Hi Erland,
The error indicates that you have the DB locked.
You can't restore when you have the Hello database opened as you have by
selecting the Hello database from teh dropdown menu.
Change databases to any other database and try again. If you still get the
error close down all the EM and QA sessions and try it again.
You can use the sp_who command to see how is in what database
kind regards
Greg O
--
Looking to use CLR in SQL 2005. Try some pre-build CLR Functions and SP
AGS SQL 2005 Utilities, over 20+ functions
http://www.ag-software.com/?tabid=38
"Erland" <Erland.Erikson@.gmail.com> wrote in message
news:1132539237.114914.201650@.o13g2000cwo.googlegroups.com...
> Hi,
> I have read restore on BOL , but i am unable to restore a SQL 7.0 back
> up to SQL Server 2000. I have tried things given in the following
> article
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpt_15ro.asp
> and i have also tried to restore the back up by using the following
> procedure.
> My database name is "Hello". I have first created a new database named
> "Hello" by using Enterprise Manager and then i opened up Query Analyzer
> and choose the database named 'Hello' from dropdown and wrote down the
> following
> Restore DATABASE HELLO
>>From disk = 'd:\Documents and
> Settings\Administrator\DEsktop\backup\Hello'
> WITH Move 'Hello' to 'D:\test\Hello.mdf'
> Go
> But i get some errors as in "Exclusive access could not be obtained
> because the datavase is in use' and 'Restore Database is terminating
> abnormally.
> Note: My SQL 7.0 back up stored in the location 'd:\Documents and
> Settings\Administrator\DEsktop\backup\Hello'. I am using SQL Server
> 2000Enterprise Edition on Windows 2000 Advanced Server.
> Please do reply me with what i ammissing. I have read quite a few
> things on BOL and on MSDN. However, i am stumped. I would really
> appreciate any help as im a newbie so please point me to the solution
> or to any article / online-resource that would lead me to the solution.
> Take care and looking forward.
> Please do reply me what i am missing here.
>|||Hi ,
Many thanks for your message. I tried the following by choosing
someother database from dropdown in QueryAnalyzer.
Restre Database Hello
from disk='d:\Documents and
Settings\Administrator\Desktop\backup\MSSQL7\BACKUP\Hello'
iwth move 'hello' to ''d:\Documents and
Settings\Administrator\Desktop\backup\MSSQL7\BACKUP\Hello.mdf'
Go
but i get the following errors
i)-Logical file 'hello' is not part of database 'hello'. Use Restore
filelistonly to list the logical file names
ii)-Restore database is terminating abnormally.
Then i tried the following
Restore filelistonly
from disk='d:\Documents and
Settings\Administrator\Desktop\backup\MSSQL7\BACKUP\Hello'
Restore Database Hello
from disk='d:\Documents and
Settings\Administrator\Desktop\backup\MSSQL7\BACKUP\Hello'
with move 'hello' to ''d:\Documents and
Settings\Administrator\Desktop\backup\MSSQL7\BACKUP\Hello.mdf'
Go
but i get the same two errors . Just to remind you i am trying to
restore a SQL 7.0 back up on SQL Server 2000 and my SQL 7.0 back is
named as Hello and store at following location
D:\Documents and
Settings\Administrator\Desktop\backup\MSSQL7\BACKUP\Hello
Now i don't have any idea what i am missing here. Any help or comments
will be highly appreciated. Please help.
Thanks
-Erland.
GregO wrote:
> Hi Erland,
> The error indicates that you have the DB locked.
> You can't restore when you have the Hello database opened as you have by
> selecting the Hello database from teh dropdown menu.
> Change databases to any other database and try again. If you still get the
> error close down all the EM and QA sessions and try it again.
> You can use the sp_who command to see how is in what database
> kind regards
> Greg O
> --
> Looking to use CLR in SQL 2005. Try some pre-build CLR Functions and SP
> AGS SQL 2005 Utilities, over 20+ functions
> http://www.ag-software.com/?tabid=38
>
> "Erland" <Erland.Erikson@.gmail.com> wrote in message
> news:1132539237.114914.201650@.o13g2000cwo.googlegroups.com...
> > Hi,
> > I have read restore on BOL , but i am unable to restore a SQL 7.0 back
> > up to SQL Server 2000. I have tried things given in the following
> > article
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpt_15ro.asp
> >
> > and i have also tried to restore the back up by using the following
> > procedure.
> > My database name is "Hello". I have first created a new database named
> > "Hello" by using Enterprise Manager and then i opened up Query Analyzer
> > and choose the database named 'Hello' from dropdown and wrote down the
> > following
> > Restore DATABASE HELLO
> >>From disk = 'd:\Documents and
> > Settings\Administrator\DEsktop\backup\Hello'
> > WITH Move 'Hello' to 'D:\test\Hello.mdf'
> > Go
> > But i get some errors as in "Exclusive access could not be obtained
> > because the datavase is in use' and 'Restore Database is terminating
> > abnormally.
> > Note: My SQL 7.0 back up stored in the location 'd:\Documents and
> > Settings\Administrator\DEsktop\backup\Hello'. I am using SQL Server
> > 2000Enterprise Edition on Windows 2000 Advanced Server.
> > Please do reply me with what i ammissing. I have read quite a few
> > things on BOL and on MSDN. However, i am stumped. I would really
> > appreciate any help as im a newbie so please point me to the solution
> > or to any article / online-resource that would lead me to the solution.
> > Take care and looking forward.
> > Please do reply me what i am missing here.
> >