arachnode.net
An Open Source C# web crawler with Lucene.NET search using SQL Server 2008/2012/2014/2016/CE An Open Source C# web crawler with Lucene.NET search using MongoDB/RavenDB/Hadoop

Completely Open Source @ GitHub

Does arachnode.net scale? | Download the latest release

Error restore BAK file: File is claimed by 'arachnode.net_EmailAddresses'(4) and 'arachnode.net_CrawlRequests'(3)

rated by 0 users
Answered (Verified) This post has 1 verified answer | 11 Replies | 2 Followers

Top 10 Contributor
229 Posts
megetron posted on Thu, Jul 30 2009 10:26 AM

Hello,

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.

Answered (Verified) Verified Answer

Top 10 Contributor
1,905 Posts
Verified by megetron

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.  Smile

This restore behavior is new in SQL 2008.

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

All Replies

Top 10 Contributor
1,905 Posts

Choose 'Overwrite the existing DB' when restoring the backup.

Mike

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

Top 10 Contributor
229 Posts

I did Tongue Tied

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

Top 10 Contributor
1,905 Posts

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... :))

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

Top 10 Contributor
229 Posts

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.

Top 10 Contributor
1,905 Posts

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?

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

Top 10 Contributor
229 Posts

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?

Top 10 Contributor
1,905 Posts

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?

Mike

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

Top 10 Contributor
229 Posts

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?

Top 10 Contributor
1,905 Posts
Verified by megetron

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.  Smile

This restore behavior is new in SQL 2008.

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

Top 10 Contributor
229 Posts

OH...so simple, but yet so frustrating. Didn't know the procedure is different. it do the job,

Thank you!!!

Top 10 Contributor
1,905 Posts

Awesome!  Glad it worked for you.  I always say, "The toughest part about software development isn't development, it's configuration..."

Mike

For best service when you require assistance:

  1. Check the DisallowedAbsoluteUris and Exceptions tables first.
  2. Cut and paste actual exceptions from the Exceptions table.
  3. Include screenshots.

Skype: arachnodedotnet

Page 1 of 1 (12 items) | RSS
An Open Source C# web crawler with Lucene.NET search using SQL 2008/2012/CE

copyright 2004-2017, arachnode.net LLC