Once a week or once a month

Running a SQL 7 system on a Windows 2000 server using Access 2000 on client
machines as a front end. System administrator currently reboots the server
once a month. Yesterday we had some weird thing with the database where
users were getting ODBC errors when trying to access it. Rebooted the
server, everything was fine. Suggested to the sa that he reboot the server
once a week. He said he already does it once a month, and that's sufficient.

My POV is that: a) doing it once a week might prevent situations such as the
one yesterday; b) even without situations like the one yesterday,
performance may be degrading over the course of the month, without our being
aware of it, and rebooting once a week might help performance.

Any thoughts on this?

Thanks!

Neil

Re: Once a week or once a month

Just because the reboot fixed the issue doesn't mean that a preventative
reboot will stop it from occuring.

A reboot might not have been needed to resolve the issue in the first place.
Possibly a configuration change
or bouncing a service could have resolved it. My advice is to spend some
time researching the issue and if
you cant find a way to resolve it then find a way to detect it and have it
perform the least intrusive form of corrective action.

-Mike

"Neil" wrote in message
news:5CY5j.76025$YL5.36846@newssvr29.news.prodigy.net...
> Running a SQL 7 system on a Windows 2000 server using Access 2000 on
> client machines as a front end. System administrator currently reboots the
> server once a month. Yesterday we had some weird thing with the database
> where users were getting ODBC errors when trying to access it. Rebooted
> the server, everything was fine. Suggested to the sa that he reboot the
> server once a week. He said he already does it once a month, and that's
> sufficient.
>
> My POV is that: a) doing it once a week might prevent situations such as
> the one yesterday; b) even without situations like the one yesterday,
> performance may be degrading over the course of the month, without our
> being aware of it, and rebooting once a week might help performance.
>
> Any thoughts on this?
>
> Thanks!
>
> Neil
>

Re: Once a week or once a month

Why does he reboot at all?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Neil" wrote in message
news:5CY5j.76025$YL5.36846@newssvr29.news.prodigy.net...
Running a SQL 7 system on a Windows 2000 server using Access 2000 on client
machines as a front end. System administrator currently reboots the server
once a month. Yesterday we had some weird thing with the database where
users were getting ODBC errors when trying to access it. Rebooted the
server, everything was fine. Suggested to the sa that he reboot the server
once a week. He said he already does it once a month, and that's sufficient.

My POV is that: a) doing it once a week might prevent situations such as the
one yesterday; b) even without situations like the one yesterday,
performance may be degrading over the course of the month, without our being
aware of it, and rebooting once a week might help performance.

Any thoughts on this?

Thanks!

Neil

Re: Once a week or once a month

OK, that's fine. But my POV is that rebooting in general, and resetting the
system memory, is a good thing to do. I take it that you disagree?

"Michael Abair" wrote in message
news:eTxBHcEOIHA.2064@TK2MSFTNGP06.phx.gbl...
> Just because the reboot fixed the issue doesn't mean that a preventative
> reboot will stop it from occuring.
>
> A reboot might not have been needed to resolve the issue in the first
> place. Possibly a configuration change
> or bouncing a service could have resolved it. My advice is to spend some
> time researching the issue and if
> you cant find a way to resolve it then find a way to detect it and have it
> perform the least intrusive form of corrective action.
>
> -Mike
>
> "Neil" wrote in message
> news:5CY5j.76025$YL5.36846@newssvr29.news.prodigy.net...
>> Running a SQL 7 system on a Windows 2000 server using Access 2000 on
>> client machines as a front end. System administrator currently reboots
>> the server once a month. Yesterday we had some weird thing with the
>> database where users were getting ODBC errors when trying to access it.
>> Rebooted the server, everything was fine. Suggested to the sa that he
>> reboot the server once a week. He said he already does it once a month,
>> and that's sufficient.
>>
>> My POV is that: a) doing it once a week might prevent situations such as
>> the one yesterday; b) even without situations like the one yesterday,
>> performance may be degrading over the course of the month, without our
>> being aware of it, and rebooting once a week might help performance.
>>
>> Any thoughts on this?
>>
>> Thanks!
>>
>> Neil
>>
>
>

Re: Once a week or once a month

See my response to Michael in this thread.

"Tom Moreau" wrote in message
news:%23LFLkcEOIHA.4196@TK2MSFTNGP04.phx.gbl...
> Why does he reboot at all?
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "Neil" wrote in message
> news:5CY5j.76025$YL5.36846@newssvr29.news.prodigy.net...
> Running a SQL 7 system on a Windows 2000 server using Access 2000 on
> client
> machines as a front end. System administrator currently reboots the server
> once a month. Yesterday we had some weird thing with the database where
> users were getting ODBC errors when trying to access it. Rebooted the
> server, everything was fine. Suggested to the sa that he reboot the server
> once a week. He said he already does it once a month, and that's
> sufficient.
>
> My POV is that: a) doing it once a week might prevent situations such as
> the
> one yesterday; b) even without situations like the one yesterday,
> performance may be degrading over the course of the month, without our
> being
> aware of it, and rebooting once a week might help performance.
>
> Any thoughts on this?
>
> Thanks!
>
> Neil
>
>

Re: Once a week or once a month

Neil (nospam@nospam.net) writes:
> OK, that's fine. But my POV is that rebooting in general, and resetting
> the system memory, is a good thing to do. I take it that you disagree?

I do. Unless there is some known issues, there is rarely any reason to
reboot SQL Server regularly. OK, so you have SQL 7, and this version is a
bit old. Nevertheless, it has the same basic architecture as subsequent
SQL Server versions. The predecessors 6.x were less stable. (In 6.0 there
was a bug that compelled you to restart the bug about every 48th day.
There was some counter somewhere that wrapped around after 49 days.)

As for rebooting helping performance, it may be the other way round.
When you reboot, the entire plan cache will be thrown away, and until
the plan has built up, the server will spend more time compiling. But
that's the only thing. Say that you have a table with date column,
into which the current date is typically inserted, and queries against
this table are typically for the recent days. If the query is a stored
procedure or is parameterised, the plan will be built using that date.
But if statistics are out of date, the estimates will be wrong, and you
may get a bad plan. Had you never restarted the server, the old good
plan would have remained in cache.

But, OK, the reverse can happen: the old plan was bad, but statistics
have been updated recently, so now you get a good plan.

As for your problem the other day, you did not include any error message,
but I would guess that it was a temporary network problem, and it would
have gone away even if you had not restarted SQL Server.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: Once a week or once a month

Why does the system memory need to be reset? I've seen SQL Servers stay up
for months and not need a reboot. That's what High Availability is all
about.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Neil" wrote in message
news:NQZ5j.69213$RX.4340@newssvr11.news.prodigy.net...
OK, that's fine. But my POV is that rebooting in general, and resetting the
system memory, is a good thing to do. I take it that you disagree?

"Michael Abair" wrote in message
news:eTxBHcEOIHA.2064@TK2MSFTNGP06.phx.gbl...
> Just because the reboot fixed the issue doesn't mean that a preventative
> reboot will stop it from occuring.
>
> A reboot might not have been needed to resolve the issue in the first
> place. Possibly a configuration change
> or bouncing a service could have resolved it. My advice is to spend some
> time researching the issue and if
> you cant find a way to resolve it then find a way to detect it and have it
> perform the least intrusive form of corrective action.
>
> -Mike
>
> "Neil" wrote in message
> news:5CY5j.76025$YL5.36846@newssvr29.news.prodigy.net...
>> Running a SQL 7 system on a Windows 2000 server using Access 2000 on
>> client machines as a front end. System administrator currently reboots
>> the server once a month. Yesterday we had some weird thing with the
>> database where users were getting ODBC errors when trying to access it.
>> Rebooted the server, everything was fine. Suggested to the sa that he
>> reboot the server once a week. He said he already does it once a month,
>> and that's sufficient.
>>
>> My POV is that: a) doing it once a week might prevent situations such as
>> the one yesterday; b) even without situations like the one yesterday,
>> performance may be degrading over the course of the month, without our
>> being aware of it, and rebooting once a week might help performance.
>>
>> Any thoughts on this?
>>
>> Thanks!
>>
>> Neil
>>
>
>

Re: Once a week or once a month

"Neil" wrote in message
news:NQZ5j.69213$RX.4340@newssvr11.news.prodigy.net...
> OK, that's fine. But my POV is that rebooting in general, and resetting
> the system memory, is a good thing to do. I take it that you disagree?
>

Yes. I disagree.

I've run systems with uptimes measured in years.

I see no value in rebooting a correctly setup system.


> "Michael Abair" wrote in message
> news:eTxBHcEOIHA.2064@TK2MSFTNGP06.phx.gbl...
>> Just because the reboot fixed the issue doesn't mean that a preventative
>> reboot will stop it from occuring.
>>
>> A reboot might not have been needed to resolve the issue in the first
>> place. Possibly a configuration change
>> or bouncing a service could have resolved it. My advice is to spend some
>> time researching the issue and if
>> you cant find a way to resolve it then find a way to detect it and have
>> it perform the least intrusive form of corrective action.
>>
>> -Mike
>>
>> "Neil" wrote in message
>> news:5CY5j.76025$YL5.36846@newssvr29.news.prodigy.net...
>>> Running a SQL 7 system on a Windows 2000 server using Access 2000 on
>>> client machines as a front end. System administrator currently reboots
>>> the server once a month. Yesterday we had some weird thing with the
>>> database where users were getting ODBC errors when trying to access it.
>>> Rebooted the server, everything was fine. Suggested to the sa that he
>>> reboot the server once a week. He said he already does it once a month,
>>> and that's sufficient.
>>>
>>> My POV is that: a) doing it once a week might prevent situations such as
>>> the one yesterday; b) even without situations like the one yesterday,
>>> performance may be degrading over the course of the month, without our
>>> being aware of it, and rebooting once a week might help performance.
>>>
>>> Any thoughts on this?
>>>
>>> Thanks!
>>>
>>> Neil
>>>
>>
>>
>
>

Re: Once a week or once a month

"Erland Sommarskog" wrote in message
news:Xns99FEEDF6C864Yazorman@127.0.0.1...
> Neil (nospam@nospam.net) writes:
>> OK, that's fine. But my POV is that rebooting in general, and resetting
>> the system memory, is a good thing to do. I take it that you disagree?
>
> I do. Unless there is some known issues, there is rarely any reason to
> reboot SQL Server regularly. OK, so you have SQL 7, and this version is a
> bit old. Nevertheless, it has the same basic architecture as subsequent
> SQL Server versions. The predecessors 6.x were less stable. (In 6.0 there
> was a bug that compelled you to restart the bug about every 48th day.
> There was some counter somewhere that wrapped around after 49 days.)
>
> As for rebooting helping performance, it may be the other way round.
> When you reboot, the entire plan cache will be thrown away, and until
> the plan has built up, the server will spend more time compiling. But
> that's the only thing. Say that you have a table with date column,
> into which the current date is typically inserted, and queries against
> this table are typically for the recent days. If the query is a stored
> procedure or is parameterised, the plan will be built using that date.
> But if statistics are out of date, the estimates will be wrong, and you
> may get a bad plan. Had you never restarted the server, the old good
> plan would have remained in cache.
>
> But, OK, the reverse can happen: the old plan was bad, but statistics
> have been updated recently, so now you get a good plan.
>
> As for your problem the other day, you did not include any error message,
> but I would guess that it was a temporary network problem, and it would
> have gone away even if you had not restarted SQL Server.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Thanks, Erland. Once again, your response is thorough and informative.

Re: Once a week or once a month

> "Neil" wrote in message
> news:NQZ5j.69213$RX.4340@newssvr11.news.prodigy.net...
> OK, that's fine. But my POV is that rebooting in general, and resetting
> the
> system memory, is a good thing to do. I take it that you disagree?
>
> "Michael Abair" wrote in message
> news:eTxBHcEOIHA.2064@TK2MSFTNGP06.phx.gbl...
>> Just because the reboot fixed the issue doesn't mean that a preventative
>> reboot will stop it from occuring.
>>
>> A reboot might not have been needed to resolve the issue in the first
>> place. Possibly a configuration change
>> or bouncing a service could have resolved it. My advice is to spend some
>> time researching the issue and if
>> you cant find a way to resolve it then find a way to detect it and have
>> it
>> perform the least intrusive form of corrective action.
>>
>> -Mike
>>
>> "Neil" wrote in message
>> news:5CY5j.76025$YL5.36846@newssvr29.news.prodigy.net...
>>> Running a SQL 7 system on a Windows 2000 server using Access 2000 on
>>> client machines as a front end. System administrator currently reboots
>>> the server once a month. Yesterday we had some weird thing with the
>>> database where users were getting ODBC errors when trying to access it.
>>> Rebooted the server, everything was fine. Suggested to the sa that he
>>> reboot the server once a week. He said he already does it once a month,
>>> and that's sufficient.
>>>
>>> My POV is that: a) doing it once a week might prevent situations such as
>>> the one yesterday; b) even without situations like the one yesterday,
>>> performance may be degrading over the course of the month, without our
>>> being aware of it, and rebooting once a week might help performance.
>>>
>>> Any thoughts on this?
>>>
>>> Thanks!
>>>
>>> Neil
>>>
>>


"Tom Moreau" wrote in message
news:uuaNHcFOIHA.4948@TK2MSFTNGP02.phx.gbl...
> Why does the system memory need to be reset? I've seen SQL Servers stay
> up
> for months and not need a reboot. That's what High Availability is all
> about.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>


Just as a general practice with Windows apps, that memory gets lost or
corrupted over time. Perhaps not with SQL Server. But there are other apps
running on it. PC Anywhere is installed as a host on that machine. I don't
know how much memory degradation, if any, occurs from that app. Occasionally
the machine is used to test the front end app (though it's not the primary
machine for that purpose).

Re: Once a week or once a month

"Greg D. Moore (Strider)" wrote in message
news:13lguvsc3jaql29@corp.supernews.com...
> "Neil" wrote in message
> news:NQZ5j.69213$RX.4340@newssvr11.news.prodigy.net...
>> OK, that's fine. But my POV is that rebooting in general, and resetting
>> the system memory, is a good thing to do. I take it that you disagree?
>>
>
> Yes. I disagree.
>
> I've run systems with uptimes measured in years.
>
> I see no value in rebooting a correctly setup system.
>
>
>> "Michael Abair" wrote in message
>> news:eTxBHcEOIHA.2064@TK2MSFTNGP06.phx.gbl...
>>> Just because the reboot fixed the issue doesn't mean that a preventative
>>> reboot will stop it from occuring.
>>>
>>> A reboot might not have been needed to resolve the issue in the first
>>> place. Possibly a configuration change
>>> or bouncing a service could have resolved it. My advice is to spend
>>> some time researching the issue and if
>>> you cant find a way to resolve it then find a way to detect it and have
>>> it perform the least intrusive form of corrective action.
>>>
>>> -Mike
>>>
>>> "Neil" wrote in message
>>> news:5CY5j.76025$YL5.36846@newssvr29.news.prodigy.net...
>>>> Running a SQL 7 system on a Windows 2000 server using Access 2000 on
>>>> client machines as a front end. System administrator currently reboots
>>>> the server once a month. Yesterday we had some weird thing with the
>>>> database where users were getting ODBC errors when trying to access it.
>>>> Rebooted the server, everything was fine. Suggested to the sa that he
>>>> reboot the server once a week. He said he already does it once a month,
>>>> and that's sufficient.
>>>>
>>>> My POV is that: a) doing it once a week might prevent situations such
>>>> as the one yesterday; b) even without situations like the one
>>>> yesterday, performance may be degrading over the course of the month,
>>>> without our being aware of it, and rebooting once a week might help
>>>> performance.
>>>>
>>>> Any thoughts on this?
>>>>
>>>> Thanks!
>>>>
>>>> Neil
>>>>
>>>
>>>


Thanks.

Re: Once a week or once a month

If memory is truly getting lost or corrupted, then I'd troubleshoot the
specific problem.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Neil" wrote in message
news:s2f6j.23284$4V6.14684@newssvr14.news.prodigy.net...

> "Neil" wrote in message
> news:NQZ5j.69213$RX.4340@newssvr11.news.prodigy.net...
> OK, that's fine. But my POV is that rebooting in general, and resetting
> the
> system memory, is a good thing to do. I take it that you disagree?
>
> "Michael Abair" wrote in message
> news:eTxBHcEOIHA.2064@TK2MSFTNGP06.phx.gbl...
>> Just because the reboot fixed the issue doesn't mean that a preventative
>> reboot will stop it from occuring.
>>
>> A reboot might not have been needed to resolve the issue in the first
>> place. Possibly a configuration change
>> or bouncing a service could have resolved it. My advice is to spend some
>> time researching the issue and if
>> you cant find a way to resolve it then find a way to detect it and have
>> it
>> perform the least intrusive form of corrective action.
>>
>> -Mike
>>
>> "Neil" wrote in message
>> news:5CY5j.76025$YL5.36846@newssvr29.news.prodigy.net...
>>> Running a SQL 7 system on a Windows 2000 server using Access 2000 on
>>> client machines as a front end. System administrator currently reboots
>>> the server once a month. Yesterday we had some weird thing with the
>>> database where users were getting ODBC errors when trying to access it.
>>> Rebooted the server, everything was fine. Suggested to the sa that he
>>> reboot the server once a week. He said he already does it once a month,
>>> and that's sufficient.
>>>
>>> My POV is that: a) doing it once a week might prevent situations such as
>>> the one yesterday; b) even without situations like the one yesterday,
>>> performance may be degrading over the course of the month, without our
>>> being aware of it, and rebooting once a week might help performance.
>>>
>>> Any thoughts on this?
>>>
>>> Thanks!
>>>
>>> Neil
>>>
>>


"Tom Moreau" wrote in message
news:uuaNHcFOIHA.4948@TK2MSFTNGP02.phx.gbl...
> Why does the system memory need to be reset? I've seen SQL Servers stay
> up
> for months and not need a reboot. That's what High Availability is all
> about.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>


Just as a general practice with Windows apps, that memory gets lost or
corrupted over time. Perhaps not with SQL Server. But there are other apps
running on it. PC Anywhere is installed as a host on that machine. I don't
know how much memory degradation, if any, occurs from that app. Occasionally
the machine is used to test the front end app (though it's not the primary
machine for that purpose).

Re: Once a week or once a month

"Neil" wrote in message
news:s2f6j.23284$4V6.14684@newssvr14.news.prodigy.net...
>
>
>
> Just as a general practice with Windows apps, that memory gets lost or
> corrupted over time. Perhaps not with SQL Server. But there are other apps
> running on it. PC Anywhere is installed as a host on that machine.

Unless there's a specific need for PCAnywhere, I'd get rid of it and
administer the machine via remote desktop.

Works much better.


> I don't know how much memory degradation, if any, occurs from that app.
> Occasionally the machine is used to test the front end app (though it's
> not the primary machine for that purpose).

Well in that csae you've got other issues with the machine.

Which if it's a purely dev machine or one where shutdowns don't impact the
business, you may be ok.

The prod environments I work in tend to be 24/7 so shutdowns are very
infrequent.

Also if you're doing a soft-reboot, that's a bit "nicer" to the hardware
than a hard-reboot which can shorten the lifespan of components.


>
>



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Re: Once a week or once a month

"Greg D. Moore (Strider)" wrote in message
news:13lj8p2grq8eab@corp.supernews.com...
> "Neil" wrote in message
> news:s2f6j.23284$4V6.14684@newssvr14.news.prodigy.net...
>>
>>
>>
>> Just as a general practice with Windows apps, that memory gets lost or
>> corrupted over time. Perhaps not with SQL Server. But there are other
>> apps running on it. PC Anywhere is installed as a host on that machine.
>
> Unless there's a specific need for PCAnywhere, I'd get rid of it and
> administer the machine via remote desktop.
>
> Works much better.
>
>
>> I don't know how much memory degradation, if any, occurs from that app.
>> Occasionally the machine is used to test the front end app (though it's
>> not the primary machine for that purpose).
>
> Well in that csae you've got other issues with the machine.
>
> Which if it's a purely dev machine or one where shutdowns don't impact the
> business, you may be ok.
>
> The prod environments I work in tend to be 24/7 so shutdowns are very
> infrequent.
>
> Also if you're doing a soft-reboot, that's a bit "nicer" to the hardware
> than a hard-reboot which can shorten the lifespan of components.
>
>
>>
>>
>
>
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>
>


One problem with remote desktop is that you can't transfer files or transfer
the clipboard contents (or can you?). I use those two functions all the
time.

Re: Once a week or once a month

Neil wrote:

> One problem with remote desktop is that you can't transfer files or transfer
> the clipboard contents (or can you?). I use those two functions all the
> time.

The clipboard contents are auto-copied whenever they change on either
side. I don't think you can transfer files, but you can work around
that with an FTP server.

Re: Once a week or once a month

Neil (nospam@nospam.net) writes:
> One problem with remote desktop is that you can't transfer files or
> transfer the clipboard contents (or can you?). I use those two functions
> all the time.

You can. You can configure this under Local Resources. I think clipboard
is shared by default, so if you put something on the clipboard on the
remote machine, it makes it to the local machine automatically.

The way to transfer files, is a little funny, though. You make the local
drives available to the remote machine, so that they appear as shared
there. Since this is a security issue, it's not recommendable to always
expose your disks.

We don't use PC Anywhere in our shop, but we use PC Duo which is a
similar product. About all customers has PC Duo clients on their
servers, and that's how we connect to them. The major advantage is
that with Remote Desktop, is that if someone else connect, you may lose
your session. With PC-Duo you can see that someone else is there.
And moving files is easier with PC-Duo than Remote Desktop.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: Once a week or once a month

"Erland Sommarskog" wrote in message
news:Xns99FFEF5871026Yazorman@127.0.0.1...
> Neil (nospam@nospam.net) writes:
>> One problem with remote desktop is that you can't transfer files or
>> transfer the clipboard contents (or can you?). I use those two functions
>> all the time.
>
> You can. You can configure this under Local Resources. I think clipboard
> is shared by default, so if you put something on the clipboard on the
> remote machine, it makes it to the local machine automatically.
>
> The way to transfer files, is a little funny, though. You make the local
> drives available to the remote machine, so that they appear as shared
> there. Since this is a security issue, it's not recommendable to always
> expose your disks.
>
> We don't use PC Anywhere in our shop, but we use PC Duo which is a
> similar product. About all customers has PC Duo clients on their
> servers, and that's how we connect to them. The major advantage is
> that with Remote Desktop, is that if someone else connect, you may lose
> your session. With PC-Duo you can see that someone else is there.
> And moving files is easier with PC-Duo than Remote Desktop.
>
>

So you'd recommend PC Duo over Remote Desktop? Is the performance as good?

Re: Once a week or once a month

OK, here's another one: no way to sent Ctrl+Alt+Del. With PCAnywhere, I can
send a Ctrl+Alt+Del and bring up Task Manager. How would one do that in
remote desktop?



"Ed Murphy" wrote in message
news:4759bb35$0$2384$4c368faf@roadrunner.com...
> Neil wrote:
>
>> One problem with remote desktop is that you can't transfer files or
>> transfer the clipboard contents (or can you?). I use those two functions
>> all the time.
>
> The clipboard contents are auto-copied whenever they change on either
> side. I don't think you can transfer files, but you can work around
> that with an FTP server.

Re: Once a week or once a month

"Neil" wrote in message
news:PyCaj.568$se5.316@nlpi069.nbdc.sbc.com...
> OK, here's another one: no way to sent Ctrl+Alt+Del. With PCAnywhere, I
> can send a Ctrl+Alt+Del and bring up Task Manager. How would one do that
> in remote desktop?

http://support.microsoft.com/kb/186624

CTRL-ALT-END


>
>
>
> "Ed Murphy" wrote in message
> news:4759bb35$0$2384$4c368faf@roadrunner.com...
>> Neil wrote:
>>
>>> One problem with remote desktop is that you can't transfer files or
>>> transfer the clipboard contents (or can you?). I use those two functions
>>> all the time.
>>
>> The clipboard contents are auto-copied whenever they change on either
>> side. I don't think you can transfer files, but you can work around
>> that with an FTP server.
>
>



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Re: Once a week or once a month

Hey, thanks, that's great.

I was also wondering about toggling between full screen and windowed mode
(Alt+Enter in PCAnywhere). I see that's CTRL+ALT+BREAK in TS. But, while
I'm glad that TS has a shortcut for that, that's a bit unwieldy, especially
since Break on my laptop is Fn+Break!! Guess I'll just have to use the mouse
to toggle.

Neil


"Greg D. Moore (Strider)" wrote in message
news:13mm5akkg0q5l4b@corp.supernews.com...
> "Neil" wrote in message
> news:PyCaj.568$se5.316@nlpi069.nbdc.sbc.com...
>> OK, here's another one: no way to sent Ctrl+Alt+Del. With PCAnywhere, I
>> can send a Ctrl+Alt+Del and bring up Task Manager. How would one do that
>> in remote desktop?
>
> http://support.microsoft.com/kb/186624
>
> CTRL-ALT-END
>
>
>>
>>
>>
>> "Ed Murphy" wrote in message
>> news:4759bb35$0$2384$4c368faf@roadrunner.com...
>>> Neil wrote:
>>>
>>>> One problem with remote desktop is that you can't transfer files or
>>>> transfer the clipboard contents (or can you?). I use those two
>>>> functions all the time.
>>>
>>> The clipboard contents are auto-copied whenever they change on either
>>> side. I don't think you can transfer files, but you can work around
>>> that with an FTP server.
>>
>>
>
>
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>
>

Re: Once a week or once a month

"Neil" wrote in message
news:YXHaj.33923$Pv2.8297@newssvr23.news.prodigy.net...
> Hey, thanks, that's great.
>
> I was also wondering about toggling between full screen and windowed mode
> (Alt+Enter in PCAnywhere). I see that's CTRL+ALT+BREAK in TS. But, while
> I'm glad that TS has a shortcut for that, that's a bit unwieldy,
> especially since Break on my laptop is Fn+Break!! Guess I'll just have to
> use the mouse to toggle.
>

Yeah there were a few there that I didn't even know about.

Very useful.


> Neil
>>
>>
>> --
>> Greg Moore
>> SQL Server DBA Consulting Remote and Onsite available!
>> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
>>
>>
>
>



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

Re: Once a week or once a month

"Greg D. Moore (Strider)" wrote in message
news:13mnm3t85tebm62@corp.supernews.com...
> "Neil" wrote in message
> news:YXHaj.33923$Pv2.8297@newssvr23.news.prodigy.net...
>> Hey, thanks, that's great.
>>
>> I was also wondering about toggling between full screen and windowed mode
>> (Alt+Enter in PCAnywhere). I see that's CTRL+ALT+BREAK in TS. But, while
>> I'm glad that TS has a shortcut for that, that's a bit unwieldy,
>> especially since Break on my laptop is Fn+Break!! Guess I'll just have to
>> use the mouse to toggle.
>>
>
> Yeah there were a few there that I didn't even know about.
>
> Very useful.
>
You'd think (just a thought) that MS would give use a dropdown with some of
the functions. Or maybe just a list of shortcuts so we could have them
handy. I guess that's too much to ask for...:-(

Re: Once a week or once a month

"Greg D. Moore (Strider)" wrote in message
news:13mnm3t85tebm62@corp.supernews.com...
> "Neil" wrote in message
> news:YXHaj.33923$Pv2.8297@newssvr23.news.prodigy.net...
>> Hey, thanks, that's great.
>>
>> I was also wondering about toggling between full screen and windowed mode
>> (Alt+Enter in PCAnywhere). I see that's CTRL+ALT+BREAK in TS. But, while
>> I'm glad that TS has a shortcut for that, that's a bit unwieldy,
>> especially since Break on my laptop is Fn+Break!! Guess I'll just have to
>> use the mouse to toggle.
>>
>
> Yeah there were a few there that I didn't even know about.
>
> Very useful.
>
>

Hey, you know, I just found out that there's an option when you connect
through RDC to apply Windows key combinations to the remote computer!
Doesn't seem to work for Ctrl-Alt-Del. But seems to work for Alt-Tab.
Haven't tried it with others yet. But that's a great thing.

Re: Once a week or once a month

On Dec 23 2007, 5:07=A0pm, "Neil" wrote:

> Hey, you know, I just found out that there's an option when you connect
> through RDC to apply Windows key combinations to the remote computer!
> Doesn't seem to work for Ctrl-Alt-Del.

It's replaced by Ctrl+Alt+End

P

Re: Once a week or once a month

"Piero 'Giops' Giorgi" wrote in message
news:3b776dc7-53a1-4904-a5ee-685c1b4e969c@u10g2000prn.google groups.com...
On Dec 23 2007, 5:07 pm, "Neil" wrote:
..
> Hey, you know, I just found out that there's an option when you connect
> through RDC to apply Windows key combinations to the remote computer!
> Doesn't seem to work for Ctrl-Alt-Del.

It's replaced by Ctrl+Alt+End

===============

Thanks, but what I was saying was that there's anoption when you connect to
apply the actual Windows key combinations to the remote computer, not the
assigned shortcuts. I was saying that it doesn't work for Ctrl+Alt+Del. In
that case you have to use Ctrl+Alt+End. But with the others, you can use the
actual keys.