lylyvn
asked on
errror in restore the database
Hi,
Please help.
This is the error when I tried to restore the database sql2005
Database name is TEST
System.Data.SqlClient.SqlE rror: The operating system returned the error '32(error not found)' while attempting 'RestoreContainer::Validat eTargetFor Creation' on 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ TEST.mdf'. (Microsoft.SqlServer.Smo)
Many thanks
ll
Please help.
This is the error when I tried to restore the database sql2005
Database name is TEST
System.Data.SqlClient.SqlE
Many thanks
ll
ASKER
Hello,
Thanks for your reply.
Yes, I have select the *.bak file (not the database file)
Thanks
Thanks for your reply.
Yes, I have select the *.bak file (not the database file)
Thanks
Is the server where the backup was created the same as the server you are restoring to?
IE is it a 32 vs 64 bit problem?
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/532f5380-3d8f-4c8c-9288-acf1eb284ecd/
IE is it a 32 vs 64 bit problem?
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/532f5380-3d8f-4c8c-9288-acf1eb284ecd/
ASKER
Hi,
Both databases on the same server (2 instances) with the same platform is NT INTEL X86
Many thanks.
LL
Both databases on the same server (2 instances) with the same platform is NT INTEL X86
Many thanks.
LL
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I did not restore by sql statement, but from MS SQL Server Management Studio, right click on Databases /Restore Database.....
Thanks.
Thanks.
Yip,
I think the .mdf you are trying to restore to is already in use.
In the Options tab of the Restore Wizard....make sure the path to your mdf and ldf IS NOT THE PATH of the place where the backup was from.
You need to make a new path and filename for the .mdf or .ldf file.
Just check it is different.
T
I think the .mdf you are trying to restore to is already in use.
In the Options tab of the Restore Wizard....make sure the path to your mdf and ldf IS NOT THE PATH of the place where the backup was from.
You need to make a new path and filename for the .mdf or .ldf file.
Just check it is different.
T
seems issue with backup file.
please take another backup and then check.
i face same issue..
please take another backup and then check.
i face same issue..
ASKER
Dear all,
I have executed the following statements and it worked:
RESTORE DATABASE AdventureWorks
FROM DISK= 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backu p\adventur eworks.BAK '
WITH MOVE 'AdventureWorks_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Data\ AdventureW orks_Data. mdf',
MOVE 'AdventureWorks_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Data\ AdventureW orks_Log.l df'
Thanks all for your help especially Tony303.
Many thanks
I have executed the following statements and it worked:
RESTORE DATABASE AdventureWorks
FROM DISK= 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backu
WITH MOVE 'AdventureWorks_Data' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Data\
MOVE 'AdventureWorks_Log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.3\MSSQL\Data\
Thanks all for your help especially Tony303.
Many thanks
Great,
So the original problem was it was trying to restore the file to a name and path that was already active?
Tony.
So the original problem was it was trying to restore the file to a name and path that was already active?
Tony.
ASKER
I did not check but I thought that was the reason.
Thanks Tony.
Thanks Tony.
If the TEST.mdf file is properly detatched (ie not in use still) then you need to re-attatch it.
https://www.zipsupport.com/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=1109