We were having a time out recently and this subject came up one colleague was asked if he was prepared to 'do time' for the company.   

Not a question but a...

On the Partner Server I submitted the command:

alter database respond_productiion set partner off

I got the message

Msg 1416, Level 16, State 1, Line 1

Database "respond_productiion" is not configured...

Thanks for that David , but no go!

If I attempt to restore I get a message stating

Msg 3104, Level 16, State 1, Line 1

RESTORE cannot operate on database xxxxxxxxxx...

how do I: "configure DSN not to use "Dynamically determine port" "  ?

That option does not appear as an option when i create or configure the File DSN 

Yelena,

I migrated the Citrix datastore using backup and restore. I can connect on the local server using the Citrix login used by the citrix server in the server farm.

I can...

That was a typo!! - 18 hour day! anyway came in this morning and rebooted the mirror server and then did new backups and restores , It is now all working...

Steve,

Thanks for that, I'd planned to back-up the non critical databases as they close for business, backup the system and 24X7 db's and restore them  in the downtime I have, then sytematically...

Raid5 = slower writes - yes, but if you have a raid5 array the more drives you have will reduce latency and I\O contention. If you have a raid array...

I spent a few years working 16+ hours a day 7 days a week, just to keep a couple of systems going, I used to get engrossed in something and...

Beware of networks when backing up\restoring from remote devices  network connections can drop for any number of reasons and this can make these processes unstable

I tried and got the first one:

select b.CounterDateTime as ' Time' ,

       b.CounterValue as 'Total % Used'

from

dbo.CounterDetails a Inner join

dbo.Counterdata b on a.counterID=B.CounterId

where  a.objectname='processor'

and a.countername='%...

  |--Stream Aggregate(GROUP BY[a].[CounterDateTime], [a].[CounterValue], .[CounterValue], [c].[CounterValue], [d].[CounterValue], [e].[CounterValue]))

       |--Nested Loops(Inner Join)

            |--Sort(ORDER BY[a].[CounterDateTime] ASC, [a].[CounterValue] ASC, .[CounterValue]...

I've done that!! do you just want me to cut and paste it into this dialogue or is there some way of attaching the saved excel file ?

How do I do this ? If I drag the doc into the window It opens it and I lose this window. You'll have to bear with me but I'm new...

Yes, I was told to do this, why - because we have several sites and the won't pay to upgrade at the target site!

I have already done  all the scripting,...