[DM2] Restoring DB(SQL)

[nettim2k]

where do i restore the db 2 usin SQL enterprise manager etc

 

[lifco]

is this about that mdf you posted yesterday ? if so its not used with sql

lif

 

[nettim2k]

im usin tds latest server files and followed his guide,i try restorin DB comes up with activation error etc,iasked td if he knew were 2 restore the db he wouldnt tell me...i been trying 2 fix it for about 3mnths i might just give up -.-

 

[jasper]

open up enterprise manger, expand the tree (+) until u get to databases under local, right click databases, and then new database, restore to that new db (name isnt important really), make sure the paths are correct in the ini files to the name of the database you have created, if using split db's then make two databases one for char records and one for data, but again, make sure the paths are correct in the ini's as explained un the updates doc

 

[nettim2k]

done all that
same problem

 

[koni]

On the other thread you have about the same problem you said your trying to restore an mdf file, as lifco has pointed out that file is not used with sql, its used with microsoft access.

You need to restore the .bak sql files, I think there located in the dbserver folder they should be called something like lom2_chardb.bak and lom2_datadb.bak or there abouts there are two database's to restore one for the dbserver and one for the m2server they will both be called .bak files not .mdf mate you will need to create two database's in sql to restore these files to and then put the relevent sql database details in the dbserevr config file and the m2server setup file.

There is a guide on how to setup the database in the release section where the files are located, have a good read through it first the thread is located here: http://www.lomcn.co.uk/forum/showthread.php?t=50091

regards

koni

 

[nettim2k]

lol just reolised the lom2_chardb,i could restore it on my laptop(i had microsoft access) thats alot

 

[koni]

lol just reolised the lom2_chardb,i could restore it on my laptop(i had microsoft access) thats alot

problem now sorted mate ?

 

[nettim2k]

no it comes upwith the same error,i can open the database(now i av access),but i try restorin the DB"s that u said(lom2_chardb.bak and lom2_charDB,bak) and comes up with the same error

 

[Turin]

By default, in SQL, when you're restoring the physical file path is given the wrong name sometimes. This might be whats causing "Device Activation Error":

If you haven't installed SQL to the default drive (C make sure you make change it in the box. Also (more commonly), you'll need to add _Data.mdf to the end of the physical file name as in the image below:

Hope that helps.
Turin