Re: Moving Citrix MPS 4 IMA database to different partition

2010-10-19 Thread James Rankin 
It did, thanks. Someone rebooted the SQL cluster just before I came in this
morning so I was swamped with "unable to connect to datastore" messages, but
it was a red herring, thankfully!

On 19 October 2010 11:18, Webster  wrote:

> Did it work?
>
>
>
>
>
> Webster
>
>
>
> *From:* James Rankin [mailto:kz2...@googlemail.com]
> *Subject:* Re: Moving Citrix MPS 4 IMA database to different partition
>
>
>
> Excellent, thanks for the confirmation guys. I thought as much but as I am
> the new guy I thought it best to double-check.
>
> Cheers,
>
> On 18 October 2010 14:44, Carl Webster  wrote:
>
> As long as nothing changes from a DSN perspective then you should be fine
> (Do I hear an echo in here?).
>
>
>
> The DSN wants to know the name of the SQL Server, the name of the database
> and the login creds.  It doesn't, or shouldn't, care about which SQL
> Instance or Partition the data store is located.
>
>
>
>
>
> Webster
>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
>
> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~
>
> ---
> To manage subscriptions click here:
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to listmana...@lyris.sunbeltsoftware.com
> with the body: unsubscribe ntsysadmin
>



-- 
"On two occasions...I have been asked, 'Pray, Mr Babbage, if you put into
the machine wrong figures, will the right answers come out?' I am not able
rightly to apprehend the kind of confusion of ideas that could provoke such
a question."

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

RE: Moving Citrix MPS 4 IMA database to different partition

2010-10-19 Thread Webster 
Did it work?

 

 

Webster

 

From: James Rankin [mailto:kz2...@googlemail.com] 
Subject: Re: Moving Citrix MPS 4 IMA database to different partition

 

Excellent, thanks for the confirmation guys. I thought as much but as I am
the new guy I thought it best to double-check.

Cheers,

On 18 October 2010 14:44, Carl Webster  wrote:

As long as nothing changes from a DSN perspective then you should be fine
(Do I hear an echo in here?).

 

The DSN wants to know the name of the SQL Server, the name of the database
and the login creds.  It doesn't, or shouldn't, care about which SQL
Instance or Partition the data store is located.

 

 

Webster


~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/>  ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

Re: Moving Citrix MPS 4 IMA database to different partition

2010-10-18 Thread James Rankin 
Excellent, thanks for the confirmation guys. I thought as much but as I am
the new guy I thought it best to double-check.

Cheers,

On 18 October 2010 14:44, Carl Webster  wrote:

> As long as nothing changes from a DSN perspective then you should be fine
> (Do I hear an echo in here?).
>
> The DSN wants to know the name of the SQL Server, the name of the database
> and the login creds.  It doesn't, or shouldn't, care about which SQL
> Instance or Partition the data store is located.
>
>
> Webster
>
>
>
> On Mon, Oct 18, 2010 at 3:24 AM, James Rankin wrote:
>
>> Are there any gotchas involved in moving a Citrix PS4 IMA database from
>> one partition to another on the same SQL Server? I've seen all the articles
>> relating to moving to a new SQL server, but there doesn't seem to be
>> anything (that my man-flu-ridden Google-fu can find) concerning simply
>> moving the database between partitions. Any pointers are gratefully
>> received, cheers,
>>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
> ~   ~
>
> ---
> To manage subscriptions click here:
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to listmana...@lyris.sunbeltsoftware.com
> with the body: unsubscribe ntsysadmin
>



-- 
"On two occasions...I have been asked, 'Pray, Mr Babbage, if you put into
the machine wrong figures, will the right answers come out?' I am not able
rightly to apprehend the kind of confusion of ideas that could provoke such
a question."

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

Re: Moving Citrix MPS 4 IMA database to different partition

2010-10-18 Thread Carl Webster 
As long as nothing changes from a DSN perspective then you should be fine
(Do I hear an echo in here?).

The DSN wants to know the name of the SQL Server, the name of the database
and the login creds.  It doesn't, or shouldn't, care about which SQL
Instance or Partition the data store is located.


Webster



On Mon, Oct 18, 2010 at 3:24 AM, James Rankin  wrote:

> Are there any gotchas involved in moving a Citrix PS4 IMA database from one
> partition to another on the same SQL Server? I've seen all the articles
> relating to moving to a new SQL server, but there doesn't seem to be
> anything (that my man-flu-ridden Google-fu can find) concerning simply
> moving the database between partitions. Any pointers are gratefully
> received, cheers,
>

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

Re: Moving Citrix MPS 4 IMA database to different partition

2010-10-18 Thread Anders Blomgren 
I could just wait for Webster to answer but:

As long as nothing changes from the DSN-perspective on the PS servers, you
should be fine.

-Anders

On Mon, Oct 18, 2010 at 10:24 AM, James Rankin wrote:

> Are there any gotchas involved in moving a Citrix PS4 IMA database from one
> partition to another on the same SQL Server? I've seen all the articles
> relating to moving to a new SQL server, but there doesn't seem to be
> anything (that my man-flu-ridden Google-fu can find) concerning simply
> moving the database between partitions. Any pointers are gratefully
> received, cheers,
>
> --
> "On two occasions...I have been asked, 'Pray, Mr Babbage, if you put into
> the machine wrong figures, will the right answers come out?' I am not able
> rightly to apprehend the kind of confusion of ideas that could provoke such
> a question."
>
> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~
> ~   ~
>
> ---
> To manage subscriptions click here:
> http://lyris.sunbelt-software.com/read/my_forums/
> or send an email to listmana...@lyris.sunbeltsoftware.com
> with the body: unsubscribe ntsysadmin
>

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin

Moving Citrix MPS 4 IMA database to different partition

2010-10-18 Thread James Rankin 
Are there any gotchas involved in moving a Citrix PS4 IMA database from one
partition to another on the same SQL Server? I've seen all the articles
relating to moving to a new SQL server, but there doesn't seem to be
anything (that my man-flu-ridden Google-fu can find) concerning simply
moving the database between partitions. Any pointers are gratefully
received, cheers,

-- 
"On two occasions...I have been asked, 'Pray, Mr Babbage, if you put into
the machine wrong figures, will the right answers come out?' I am not able
rightly to apprehend the kind of confusion of ideas that could provoke such
a question."

~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~   ~

---
To manage subscriptions click here: 
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe ntsysadmin