Restoring from 2000 backup to 2005 instance

I did a backup of a 2000 database using the 2005 management studio. I then
created a blank database on my 2005 instance. I then tried to do a database
restore to the new 2005 database. I got an error:
System.Data.SqlClient.SqlError: The backup set holds a backup of a database
other than the existing 'Winstis' database. (Microsoft.SqlServer.Smo)
I even tried the option to Overwrite Existing database and I got a different
error:
System.Data.SqlClient.SqlError: The operating system returned the error '32
(The process cannot access the file because it is being used by another
process.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on
'D:\Program Files\Microsoft SQL Server\MSSQL\Data\test.ldf'. (Microsoft.
SqlServer.Smo)
Also the 2005 instance database is on C:\Program Files\Microsoft SQL Server\
MSSQL.1\MSSQL\Data\Winstis_Data.mdf
and the 2000 instance is on
D:\Program Files\Microsoft SQL Server\MSSQL\Data\Winstis_Data.mdf
How can I accomplish getting the database from 2000 to 2005?
--
Message posted via http://www.sqlmonster.comHello,
Do not create the blank database instead do the below steps:-
1. Do the SQL Server 2000 backup using Backup Database WITH INIT
2. Copy the .BAK file to SQL 2005 machine
3. Create the required folders for MDF and LDF in SQL 2005 server
3. Do the below command
RESTORE DATABASE Winstis FROM DISK='D:\backup\dbbackup2000.bak'
with MOVE 'LogicalMDFName' to 'd:\Data\Winstis_Data.mdf',
with MOVE 'LogicalLDFName' to 'd:\Data\Winstis_log.ldf',stats=2
Ge the logical MDF and LDF names using RESTORE FILELISTONLY command
Thanks
Hari
"dcuff via SQLMonster.com" <u12346@.uwe> wrote in message
news:6941157063204@.uwe...
>I did a backup of a 2000 database using the 2005 management studio. I then
> created a blank database on my 2005 instance. I then tried to do a
> database
> restore to the new 2005 database. I got an error:
> System.Data.SqlClient.SqlError: The backup set holds a backup of a
> database
> other than the existing 'Winstis' database. (Microsoft.SqlServer.Smo)
> I even tried the option to Overwrite Existing database and I got a
> different
> error:
> System.Data.SqlClient.SqlError: The operating system returned the error
> '32
> (The process cannot access the file because it is being used by another
> process.)' while attempting 'RestoreContainer::ValidateTargetForCreation'
> on
> 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\test.ldf'. (Microsoft.
> SqlServer.Smo)
> Also the 2005 instance database is on C:\Program Files\Microsoft SQL
> Server\
> MSSQL.1\MSSQL\Data\Winstis_Data.mdf
> and the 2000 instance is on
> D:\Program Files\Microsoft SQL Server\MSSQL\Data\Winstis_Data.mdf
> How can I accomplish getting the database from 2000 to 2005?
> --
> Message posted via http://www.sqlmonster.com
>|||Thanks for the response Hari. This procedure will not affect the Winstis
database on SQL2000 will it. That is our production instance. I only want to
copy the database to the SQL2005 instance not a complete move. That way I can
test our ERP on it.
Thanks,
David
Hari Prasad wrote:
>Hello,
>Do not create the blank database instead do the below steps:-
>1. Do the SQL Server 2000 backup using Backup Database WITH INIT
>2. Copy the .BAK file to SQL 2005 machine
>3. Create the required folders for MDF and LDF in SQL 2005 server
>3. Do the below command
> RESTORE DATABASE Winstis FROM DISK='D:\backup\dbbackup2000.bak'
> with MOVE 'LogicalMDFName' to 'd:\Data\Winstis_Data.mdf',
> with MOVE 'LogicalLDFName' to 'd:\Data\Winstis_log.ldf',stats=2
>Ge the logical MDF and LDF names using RESTORE FILELISTONLY command
>Thanks
>Hari
>>I did a backup of a 2000 database using the 2005 management studio. I then
>> created a blank database on my 2005 instance. I then tried to do a
>[quoted text clipped - 25 lines]
>> How can I accomplish getting the database from 2000 to 2005?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200611/1|||>I did a backup of a 2000 database using the 2005 management studio. I then
> created a blank database on my 2005 instance. I then tried to >do a
> database
You don't need to create a blank database. Do just restore commnd
"dcuff via SQLMonster.com" <u12346@.uwe> wrote in message
news:694268af1752f@.uwe...
> Thanks for the response Hari. This procedure will not affect the Winstis
> database on SQL2000 will it. That is our production instance. I only want
> to
> copy the database to the SQL2005 instance not a complete move. That way I
> can
> test our ERP on it.
> Thanks,
> David
> Hari Prasad wrote:
>>Hello,
>>Do not create the blank database instead do the below steps:-
>>1. Do the SQL Server 2000 backup using Backup Database WITH INIT
>>2. Copy the .BAK file to SQL 2005 machine
>>3. Create the required folders for MDF and LDF in SQL 2005 server
>>3. Do the below command
>> RESTORE DATABASE Winstis FROM DISK='D:\backup\dbbackup2000.bak'
>> with MOVE 'LogicalMDFName' to 'd:\Data\Winstis_Data.mdf',
>> with MOVE 'LogicalLDFName' to 'd:\Data\Winstis_log.ldf',stats=2
>>Ge the logical MDF and LDF names using RESTORE FILELISTONLY command
>>Thanks
>>Hari
>>I did a backup of a 2000 database using the 2005 management studio. I
>>then
>> created a blank database on my 2005 instance. I then tried to do a
>>[quoted text clipped - 25 lines]
>> How can I accomplish getting the database from 2000 to 2005?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200611/1
>