Hi,
I have backup of data from SQL Server 7.0 and now when i'm trying to restore it into SQL Express 2005, I'm getting following error......
--
Msg 3154, Level 16, State 2, Line 1
The backup set holds a backup of a database other than the existing 'GOSLDW' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
--
Here is SQL i'm using to restore database,
RESTORE DATABASE GOSLDW
FROM DISK = 'C:\sqlserverData\GOSLDW'
WITH MOVE 'GOSLDW' TO 'C:\sqlserverData\GOSLDW.mdf',
MOVE 'GOSLDW' TO 'C:\sqlserverData\GOSLDW.ldf'
GO
Why i'm getting this error? Am i missing anything here?
Thanks in advance for your HELP.
- R
There is already a database existing with this name, you either have to drop the database first or replace it with the WITH REPLACE option, see BOL for more details.HTH, jens Suessmeyer.
http://www.sqlserver2005.de
|||
Thanks for you reply...
After droping database and runing same query again I got message back that database is restore successfully but I don't see any database created.
How i can see this restored database?
I'm new in this SQLServer world..... Thanks for your help.
-R
|||When you say you can't see it where are you looking? If this is the treeview in SSMS then try right clicking on the databases node and select refresh. If yuo still can not see it then try executing the following query
select * from sys.databases
|||I guess you are just connected to the wrong instance, use the following command while connected to the *assumed* right instance to see wheter the database appears in the list: SELECT * FROM sys.databases If not the instance does not hold the database you want to use and you restore the database on another system than the wanted :-|
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Thanks now its working fine. I had to stop server and restart to see all database.
Thanks for you help,
R
|||You should not have to do that, a simple refresh of the node should allow you to see them all.
No comments:
Post a Comment