I am trying to restore bkp file on SQL SERVER 2008, and keep getting this:System.Data.SqlClient.SqlError: File 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\arachnode.net.ndf' is claimed by 'arachnode.net_EmailAddresses'(4) and 'arachnode.net_CrawlRequests'(3). The WITH MOVE clause can be used to relocate one or more files. (Microsoft.SqlServer.Smo)I also tried to change the folder's name to the correct one inside the application directory but still get this error. what should I do ? please help.
OK - the problem is that you have created a database named arachnode.net, but this database, although named the same isn't arachnode.net. So, delete the database you created and just restore the backup.
This restore behavior is new in SQL 2008.
For best service when you require assistance:
Choose 'Overwrite the existing DB' when restoring the backup.
I did On installation I changed the COLLATION property to different language. could it be it?
I have posted the question on asp.net forums just in case. hope the help will come quick, I cant progress, I am stuck :(http://forums.asp.net/p/1453831/3323844.aspx#3323844
Shoot. OK. I know that Kevin ran into this issue. I just reset the search indexes because there was a problem (bug) with CommunityServer and not indexing properly, so I'm looking at the DB manually to see where the possible solution is documented.
I think I know what the problem is. I renamed the database files to reflect their intended usage. Can you delete your existing arachnode.net database and try the restore? (I promise this is that last version I make without an upgrade script... :))
I have download the new zipped bkp file but when unzipping it, the BKP file was last changed on 26/07/2009. are you sure you have uploaded the fix? I have tried this file and recieving the same error.
BTW I don't have any problem uploading without script this particular problem.
You are trying to upgrade the 1.1 version, right? In this case this problem isn't AN specific, rather that you are using the 2005 version of the database, and the 1.2 version is 2008, and so SQL sees the databases as different databases.
Did you try deleting the existing AN database?
I am sorry I didn't explain good enough. I am not trying to upgrade any version.
I am starting a new arachnode.net project. I downloaed the 1.2 new version and from the BKP file trying to create the databse. I created a new arachnode.net database and restore using the bkp file provided. this is nothing to do with 1.1 version. and no upgrade is needed. the issue is a new installation.
I installed a new version of SQL server 2008 an windows 2003 server, and the annoying errors keep prompting whenever the restore action fired....
what should I do?
OK. Got it. Just for clarification, did you create the arachnode.net database and then try to restore the database from backup?
I have a fresh SQL2008 instance that has never seen AN.net - I'l try a restore here just in case something has gone haywire. You should be able to restore without any problems... are there existing database files for AN.net in the restore location?
That was quick:)Yes. I create database named arachnode.net and then trying to restore. I don't know another way doing so.There are no files in the restore location. I have download a new fresh 1.2 version, and unzipped the BKP file to the root folder od the project. I even tried to create a folder "database" and copy the bkp file into it, and tried to restore from there. I did the same procedure on 1.1 version and never got any problems...
Could it be because I have SQL server 2008 and 2005 installd on the same machine? could it be it?
OH...so simple, but yet so frustrating. Didn't know the procedure is different. it do the job,
Awesome! Glad it worked for you. I always say, "The toughest part about software development isn't development, it's configuration..."