I recommend you read up on clustering.. Clustering has nothing to do with the reporting and the reporting service, as merely it's for disaster recovery, business resumption and importantly availablity...

I see, hmmm, I would still watch out for the hardware compatilities and RAID array controller compatibilities too..

make sure you have a very good verified backup of all the databases...

Now, you are referring to an entire solution for a proper database management system.

Let me see if I can analyze your question and therefore be able to answer component at...

I agree with Jeffrey.

AD Service accounts:> for backups and other administrative actions.

the other system level accounts are mostly being created by the OS and other installed systems and applications.. I...

Like one of the replier indicated, backup and restore.. Or, backup, detach, copy detached to the new destination and attach.

You can not just copy the drives that have...

useful information, thank you Jeffrey

Very good point, in fact my colleague and I were working on this and I have converted the "run as" line from ssis to tsql and the "parse" option /...

Very good point Flo. You see VFP (visual foxpro) is very susceptible to index and other table related damage when other sources link and tap into the database tables in...

love the answer.... I can not agree more...

thank you again during my lapse of reasoning.. appreciate it.

I am sure I will be picking your brain again and again..

Thank you for the reply! Good point and I have discussed this with Symantec and they were trying to tell me that it's capable of doing it.

I believe, based...

The link between the two servers may not be available at all times, imperfect world, thus the transactions can be locally preserved for that matter.

🙂

flextech,

Oh, one thing that I was going to add to your comment was that; probably it would be a good idea to keep the "transaction" log on the VFP side...

There is notification that tells me that there is a message but seem to be unable to open it..

hmmm 🙁

flextech,

absolutely right. The structure of both realms are identical at this point. All objects are names the same. Therefore, things are a bit easier to work with. 🙂

Thus, the...

flextech,

wow, since version six.. ouch..

yes, you are right the odbc is not a good idea and if we keep the idea of having a "transaction" log in the middle...