October 5, 2006 at 8:29 am
Can anyone please list the rule of thumb main problems when trasfering an analytical database from one machine to another.
I've transferred my tables and SPROCs and still have problems. Everything starts fine, SPROCs activate each other, tables are created and then bang for some reson a table is not created and the flow is interrupted. Why is this? The system is an exact copy of what works on another machine. Maybe it is something to do with the configuration of the database, memory allocation, maybe it is the fact that one of these is a Win 2000 machine and the one that does not work is Win XP. Does anyone have any ideas about what they would look at first?
October 6, 2006 at 12:53 am
Do you have the required sql login on the xp server?
Is their any specific table giving problem?
------------
Prakash Sawant
http://psawant.blogspot.com
October 6, 2006 at 3:04 am
I'm not sure whether it is a table problem or a SPROC problem.
October 6, 2006 at 3:37 am
Are you trying to restore from backup OR restoring from script?
------------
Prakash Sawant
http://psawant.blogspot.com
October 6, 2006 at 4:45 am
Script. We have tried several things but have not had a chance to test it yet. These are as follows:
We changed the minimum query size, we removed 3 processors from being assigned to the database system, we increased the size of the database.
October 6, 2006 at 5:23 am
If the collation is the same, I always create a database with the same name and copy the full back up file of the database to the new server.
October 6, 2006 at 7:51 am
Simplest thing I have found is detach the database files on the first server, copy them to the second (if v. big then copying first to some sort of NTFS formatted removable media like one the the large ext. USB2 drives you can pick up for peanuts now is quickest way to move) then attach the files again on new server - I have never had any problems this way and it is super quick
James Horsley
Workflow Consulting Limited
October 6, 2006 at 8:16 am
So, would it be sufficient to backup a database and then copy the .BAK files from one machine to another and then restore the database on the new machine?
October 6, 2006 at 8:30 am
Yes, this should give you all the objects to the new server but you need to map the server & db logins.
------------
Prakash Sawant
http://psawant.blogspot.com
October 6, 2006 at 8:34 am
What do you mean you need to map the server ?
I always go to the server and make the database as the name from the old server and do restore and set up the login.
October 6, 2006 at 8:45 am
What i mean by server & db login maping is, when we restore the DB from one server to another then all the login's under the db will be restored but they won't be having any maping with your server level login's.
In this case we need to do a maping between them.
------------
Prakash Sawant
http://psawant.blogspot.com
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply