SQL 2005 Database restoring error?

cunny

Hey guys, I need your help!

Somebody have maDe a backup from Navision 4.0 sp3 which use the SQL 2000 Server. And because of the database is very huge, navision generated 10 files (fin.fbk--fin9.fbk.) when we made a backup from Navision. And we want to imigrate the database from sql 2000 server to sql 2005 server. When restoring process indicated 40% the whole process was interrupted by an error"can not find the file X:\backup\fin4.fbk".

I have checked the the file but it's there in the right path.

What will be the problem?

Best regards,

cunny

diptish.naskar

Buddy, I have done the same thing but not with so many backup files but with 4backup files and it has worked properly for me atleaset. What you can again do is (if possible) take a backup again from navision and then try it once more.

Waldo

You can also detach the SQL2000 DB and attach to SQL2005.
Or you can do a SQL backup/restore.
Don't forget to switch the compatibility level in the database properties to 90 though... .
This has only one disadvantage. If you want to reconfigure datafiles in filegroups, it's not so easy to do

Sorcerer

Hi there,

we had the same problem. You have to make a new backup and name the first file backup01.fbk, so that there is a number in the first file.

Aferwards it was no problem to import it.

David_Singleton

Sorcerer wrote:

Hi there,

we had the same problem. You have to make a new backup and name the first file backup01.fbk, so that there is a number in the first file.

Aferwards it was no problem to import it.

I have definitely also had this same thing happen. As sorcerer says ALWAYS end your back name in "01".

Diptish, be aware that it doesn't happen all the time, and can be dependent on many different factors, so just because it works in many situations, does not mean it will work in all situations. Still I would recommend that you also add the 01 suffis in your fbk name, it just makes life easier.

diptish.naskar

Hi David,

Thnaks for the advice, see the simple way is alsways to take a new backup and restore it, but you have actually missed out something..you have actually asked to create a backup with a suffix, can you tell me few things..

1. Can you tell at what point of time when we take a backup of navision it splits into two(for the first time, does it prompts the user that user to where the file will be stored?)

2. How many times have you taken a backup and split the file into various volumes?

I beleive for both the questions the answer is NO it cannot be done. The reason Navision has got an inbuilt feature to do the same and hence adding the suffix of '001' is not going to help anyway dear. A proper backup is the only solution.

DenSter

Diptish, you should listen to Sorcerer's and David's advice. They are both very experienced people, and they have a lot of knowledge to offer.

NAV backups have a maximum file size of 2GB. Once the backup file is bigger than that, NAV will split it up into multiple parts, and it increments the number at the end of the file name, into the same folder. To restore the file into another database, you put all the files in the same folder, and you start the restore with the first file. The restore process will automatically pick up the next files. That is simply how the software works.

diptish.naskar

Denster,

Thanks for the advice, but sometimes down the line...adding a suffix of 01 would however would not make life easier....and why not go with the practical thing..have you tried to answer the two questions that I have earlier posted..if you do have the answer and the is 'Yes' for the same, then the point of adding 01 as a suffix holds...and eventually what will happen if you add a suffix 01 to the backup...?

Take for example the name of the backup earlier was ABC.FBK which had broken down to say 10 files and now if I listen to the earlier posts and name the backup file as ABC01.FBK, now can you tell me what will be the name of the other files??

I beleive you have the answer...?Do let me know and what difference it would create in the backup method..?

Eagerly waithing for your response..

David_Singleton

DenSter wrote:

Diptish, you should listen to Sorcerer's and David's advice. They are both very experienced people, and they have a lot of knowledge to offer.
...

I think that this is another one of those cases that you love so much, of "don't answer the question, just tell me what I want to hear".

DenSter

diptish.naskar wrote:

Denster,

Thanks for the advice, but sometimes down the line...adding a suffix of 01 would however would not make life easier....and why not go with the practical thing..have you tried to answer the two questions that I have earlier posted..if you do have the answer and the is 'Yes' for the same, then the point of adding 01 as a suffix holds...and eventually what will happen if you add a suffix 01 to the backup...?

Take for example the name of the backup earlier was ABC.FBK which had broken down to say 10 files and now if I listen to the earlier posts and name the backup file as ABC01.FBK, now can you tell me what will be the name of the other files??

I believe you have the answer...?Do let me know and what difference it would create in the backup method..?

Eagerly waithing for your response..

Have you even read the responses? :shock: The answer is right there. I am not going to repeat it.

DenSter

David Singleton wrote:

I think that this is another one of those cases that you love so much, of "don't answer the question, just tell me what I want to hear".

Q: I have a question
A: I have an answer
Q: but that will not be the right answer
:shock:
*baffled in amazement*

Waldo

diptish.naskar wrote:

Denster,

Thanks for the advice, but sometimes down the line...adding a suffix of 01 would however would not make life easier....and why not go with the practical thing..have you tried to answer the two questions that I have earlier posted..if you do have the answer and the is 'Yes' for the same, then the point of adding 01 as a suffix holds...and eventually what will happen if you add a suffix 01 to the backup...?

Take for example the name of the backup earlier was ABC.FBK which had broken down to say 10 files and now if I listen to the earlier posts and name the backup file as ABC01.FBK, now can you tell me what will be the name of the other files??

I beleive you have the answer...?Do let me know and what difference it would create in the backup method..?

Eagerly waithing for your response..

Oh ... please [-o<
People are giving you solutions to your problem ... at least try them out :shock: