Thanks Folks...
There were a few issues to address witht the DBA, but once we were
both on the same page - we got everything up and running.
It was at least comforting to know that others had been successful at
this endeavour; therefore, all that was needed was a little BST (Blood
Sweat and
Sorry forgot to add the following:
Lessons Learned:
1) Restoring a 2005 SQL database to a 2008 SQL database may have been
the culprit.
2) Even if your 2008 database is running in 2005 Mode - this will
cause unusual problems.
3) ar.cfg needs to be updated.
4) For some reason the ARAdmin User gets
We have a complete automated solution utilizing SSIS Scripts which will:
1. 7zip the complete last night full backup of production
2. FTP the compressed file to the target system (test / dev / etc)
3. Uncompress the remote file
4. shutdown remedy processes
5. restore the database
Hi Folks...
I am going to ask this question again - because I have never seen a
definitive answer.
Here is what we have:
1) Independent SQL Database Tier (2005).
2) ARSystem Application Tier (7.5 Patch 2).
3) Mid-tier (7.5 Patch 2).
Environments:
1) Sandbox
2) Development
3) Staging
4)
: SQL Database Replication
Hi Folks...
I am going to ask this question again - because I have never seen a
definitive answer.
Here is what we have:
1) Independent SQL Database Tier (2005).
2) ARSystem Application Tier (7.5 Patch 2).
3) Mid-tier (7.5 Patch 2).
Environments:
1) Sandbox
2
list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Elry
Sent: Thursday, July 15, 2010 7:47 AM
To: arsl...@arslist.org
Subject: SQL Database Replication
Hi Folks...
I am going to ask this question again - because I have never seen a
definitive answer.
Here is what we have:
1
...@gmail.com]
Sent: Thursday, July 15, 2010 8:46 AM
To: arslist@ARSLIST.ORG
Subject: SQL Database Replication
Hi Folks...
I am going to ask this question again - because I have never seen a
definitive answer.
Here is what we have:
1) Independent SQL Database Tier (2005).
2) ARSystem Application Tier (7.5
From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on
behalf of Elry [elryal...@gmail.com]
Sent: Thursday, July 15, 2010 8:46 AM
To: arsl...@arslist.org
Subject: SQL Database Replication
Hi Folks...
I am going to ask this question again - because I have never seen
ssion list(ARSList) [arsl...@arslist.org] on behalf of Elry [elryal...@gmail.com] Sent: Thursday, July 15, 2010 8:46 AM To: arsl...@arslist.org Subject: SQL Database Replication Hi Folks... I am going to ask this question again - because I have never seen a definitive answer. Here is what we have: 1) I
going.
Guillaume
From: Action Request System discussion list(ARSList) [arsl...@arslist.org]
on behalf of Elry [elryal...@gmail.com]
Sent: Thursday, July 15, 2010 8:46 AM
To:arsl...@arslist.org
Subject: SQL Database Replication
Hi Folks
y 15, 2010 8:46 AM To:arsl...@arslist.org Subject: SQL Database Replication Hi Folks... I am going to ask this question again - because I have never seen a definitive answer. Here is what we have: 1) Independent SQL Database Tier (2005). 2) ARSystem Application Tier (7.5 Patch 2). 3) Mid
Guillaume
From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on
behalf of Elry [elryal...@gmail.com]
Sent: Thursday, July 15, 2010 11:36 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Database Replication
Thanks Terry...
Just spoke
file, make sure you point that file to the right
database server, or you might end up having a test server point to production...
Joe
From: Elry elryal...@gmail.com
To: arslist@ARSLIST.ORG
Sent: Thu, July 15, 2010 8:46:57 AM
Subject: SQL Database Replication
15, 2010 11:44 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Database Replication
**
Elry,
One of the reasons answers differ and vary is the configuration. All depends on
what applications you are using. Does the application have configuration data
that hard codes server names like AIE would
From: Elry elryal...@gmail.com
To: arsl...@arslist.org
Sent: Thu, July 15, 2010 8:46:57 AM
Subject: SQL Database Replication
Hi Folks...
I am going to ask this question again - because I have never seen a definitive
answer.
Here is what we have:
1) Independent
:36 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Database Replication
Thanks Terry...
Just spoke to the DBA - what he actually did was:
1) Made a backup copy of Production.
2) Restored the backup copy to the Sandbox.
This appears to be quite different from replication - could this be
the source
just fine.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Elry
Sent: Thursday, July 15, 2010 9:36 AM
To: arsl...@arslist.org
Subject: Re: SQL Database Replication
Thanks Terry...
Just spoke to the DBA - what he
application, that function works just fine.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Elry
Sent: Thursday, July 15, 2010 9:36 AM
To: arsl...@arslist.org
Subject: Re: SQL Database Replication
Thanks Terry
address instead
of @ in the database.
Joe
From: Elry elryal...@gmail.com
To: arslist@ARSLIST.ORG
Sent: Thu, July 15, 2010 11:50:26 AM
Subject: Re: SQL Database Replication
Thanks Joe...
The application that we are using is not ITSM. It is a custom application
From: Elry elryal...@gmail.com
To: arsl...@arslist.org
Sent: Thu, July 15, 2010 11:50:26 AM
Subject: Re: SQL Database Replication
Thanks Joe...
The application that we are using is not ITSM. It is a custom application
that
we have built.
All the developers were warned
)
[mailto:arsl...@arslist.org] On Behalf Of Elry
Sent: Thursday, July 15, 2010 9:36 AM
To: arsl...@arslist.org
Subject: Re: SQL Database Replication
Thanks Terry...
Just spoke to the DBA - what he actually did was:
1) Made a backup copy of Production.
2) Restored the backup
Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Elry
Sent: Thursday, July 15, 2010 1:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Database Replication
Well...
We were able to get the system up and running, but I noticed
list(ARSList) [mailto:
arsl...@arslist.org] On Behalf Of Elry
Sent: Thursday, July 15, 2010 1:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Database Replication
Well...
We were able to get the system up and running, but I noticed that
there are some odd things:
1) All structures and data
From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on
behalf of Elry [elryal...@gmail.com]
Sent: Thursday, July 15, 2010 2:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Database Replication
Well...
We were able to get the system up and running, but I
] On Behalf Of Guillaume Rheault
Sent: Thursday, July 15, 2010 12:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Database Replication
Hey Elry,
One more thing that I forgot to mention to you, that is a new feature with ARS
7.5, I believe.
As you may know, AR Server license keys are stored
it will be smoother.
Guillaume
From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on
behalf of Elry [elryal...@gmail.com]
Sent: Thursday, July 15, 2010 2:12 PM
To: arsl...@arslist.org
Subject: Re: SQL Database Replication
Well...
We
26 matches
Mail list logo