Hi,

I'm trying to restore a SQL 2000 database to an SQL 2005 database but when I select the database to restore, in the logical file name boxes it says "master" and "mastlog". I have checked and the file which is I'm trying to restore is not in the master database. Why would it say this as also the database will not restore as it gives an sysnsobjs object aready exists error.

could anybody pls?

__________________
S.VinothkumaR
Behind me is infinite power,
Before me is Endless Possibility,
Around me is Boundless Opportunity,
Why should I fear!

How you are trying to restore the database?

What happens if you try to restore it using T-SQL?

Restore it with a different database name (don't use the defaults) and change the logical names to match this as well.

__________________
Krishnakumar.S
Beware of Everything -that is un true; stick to the Truth shall succeed slowly but steadily

Hi all,

I can understand why this is causing you some confusion as it is not blatantly obvious - but you are able to type over where it says "Master" and add the name required for your DB restore.

__________________
thanx n regards
jeyaprakash.c