move database to different server

[vasileiosfasolis]

hello to all!

does anyone know if it is possible to move a database from one server to another one?

i am asking because a colleague made a backup from the database which was in server A, restored it to the server B and unfrotunatelly, by trying to make an invoice a message is displayed about document series. i checked the document series and numbering and is right.

i tried to do the same action in the server A and i did not have any problem.

do tyou know if the problem is the movement of the database from one server to another?

[vinayak_chavan · Accepted solution]

Check the date of server B

[vasileiosfasolis · Accepted solution]

the date of what should i check Chavan?

i dont actually know what do you mean.

[vinayak_chavan · Accepted solution]

could y give me team viewer so i can check myself?

[vasileiosfasolis · Accepted solution]

could you please send me an email to vasileios@fasolis.net in order to give you my id

[vinayak_chavan · Accepted solution]

check your mailbox iam ready with team viewer

[former_member186095]

Hi,

you can move database by backup or detach the database from one server to other server as long as the database platform between both server is same or at least one of them is higher version than other.

What I mean here if the server A installed with SQL server 2008 R2 std edition SP1, then the server B must also have the same SQL version or higher version.

So, you can move the database from server A to B or vice versa only for the same sql server version. But you can't move the database to the lower version of SQL server. Example the database is created or restored in the sql server 2008 R2 std edition, and you restored to sql server 2008 std edition. You will fail if you do that.

Rgds,

[vasileiosfasolis]

Hi Jimmy

the version of SQL server is the same

the error displayed is the following

To generate this document, first define numbering series in the Administration module. “Message 131 – 3

[former_member541807]

hi,

the answer is YES. you can move one Database from one Server to another Server. you can use two methods to move database

1. backup and restore database
2. detached and attached database

to resolve the document numbering series Goto

1. Administration
2. System Initializatin
3. Document Numbering

Set the default Period indicator

regards,

Fidel

[vasileiosfasolis]

Hi Fidel

it is already set the same as posting period

[former_member186095]

Hi,

Go on. You can move teh database.

For the error numebring series, try the solution in these threads:

http://scn.sap.com/thread/974651

http://scn.sap.com/thread/1646377

Good luck

JimM

[vasileiosfasolis]

Hi Jim

as far as i read, everything seems to be ok

would you mind to check it with me with teamviewer?

[former_member186095]

Hi,

I would not mind to check but I won't be available until the next 3 hours. Can you wait until the next 3 hours ?

Rgds,

JimM

[vasileiosfasolis]

i will be here for the next 4 hours max

i will be here for at least 3 hours..

send me an email if you want to at vasileios@fasolis.net

[Former Member]

Have you checked the license allocation in the new database?

[vasileiosfasolis]

Hi Julie

could you please tell me what do you mean?what and where should i do?