How To Split A Database

Savatage

I'm about to split out database into 2.

Does someone have all the steps involved - so I don't screw it up.
including do I stopthe service & restart.. Parameter changes, etc etc.

right now it's on E:\DATABASE.FDB
I'm Gonna make it
E:\DATABASE.FDB+F:\DATABASE.FDB

Luc_VanDyck

I think you can do it easily using a Navision client, with the File -> Database -> Expand option. Click on the "Advanced" button, and you are able to create a new line with path & filename for the 2nd part of your database. No need to change server settings. But make sure you modify your backup scripts to include this new database-file.

kine

Yes, but better is to backup, create new DB with as many parts as possible (depends on HDD pairs count), restore the backup into this new DB - why? To have balanced DB parts - the data will be in both (all) files, if you just extend the DB, main part of data will be in the first file... but it is on you, if you have time to do backup/restore of whole DB...

kriki

kine wrote:

Yes, but better is to backup, create new DB with as many parts as possible (depends on HDD pairs count), restore the backup into this new DB - why? To have balanced DB parts - the data will be in both (all) files, if you just extend the DB, main part of data will be in the first file... but it is on you, if you have time to do backup/restore of whole DB...

This you need the performance given by the extra disks immediately.
You can also choose NOT to do it. After a while, you will see that the data gets divided. Remember in Navision: also the MODIFY in reality are INSERT's because of the version-system of the Navision-DB.
Of course this also depends on how the data evolves.
E.g. if you have a DB of 20GB with 15GB of static data (posted invoices, Entries,...) and you create a new DB-file of 20 GB, most of the time the DB, will write new records in the second DB-file to get it filled up. In this case it is best to make a backup/restore to divide the data.

Savatage

OK, I'm shi**ing a brick everytime I get up enuf nerve to do this.

I make a full backup for the database 17gb - I transfer it as is to another computer & another drive on the server - just to have 2.

the Drive it is on now is 18gb and the database is 17gb. That's why I added another drive and would like to split it 9gb on each.

So I have to delete the 17gb database in order to fit the new 9gb half that is replacing it.

I also make a Navision Backup so I can restore. 3 files 2GB each approx.

Now once I have all these backups I feel better but then do I delete the Database or do I delete the company.

I have deleted the database but when I enter database->new>

server name->navision1
database e:\test1.fdb+f:\test2.fdb - it doesn't seem to like that and I get a message like "the old database name can't be found" & it won't let me create a new database (& I start freaking)

Do I have to stop the service - should I add parameters to the service with the new info?

This is the first time I've tried this. I'm sure it's just nerves but I can afford to screw this up. At this point I usually copy back the database and try it again in two weeks.

](*,) ](*,) ](*,)

kine

No, you just need to create the first file, through File-Database-Expand add another DB file and after that, restore the backup. The filename1+filename2 is not possible when creating the DB...

Savatage

I realized that after - thanks I'll try it again =D>

Savatage

Oh by the way - Done!

Not the super speed increase I was hoping for - but no complaints.

3 raid 1's
using
4 - 18 GB SCSI 15k
2 - 32 GB SCSI 15k
OS on 1 Database split on 2.