Viewing 15 posts - 4,651 through 4,665 (of 6,676 total)
What version of the client tools are you installing? Have you tried upgrading the client tools to SP3 to see if that helps?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 20, 2009 at 1:41 pm
TheSQLGuru (8/20/2009)Several incorrect statements there. It can occur on a SQL Server only box that the OS asks for memory back. Also SQL Server does give memory...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 20, 2009 at 12:44 pm
Yes, you can more or less ignore the index fragmentation for those tables. What I normally do is schedule a weekly index rebuild for smaller systems and just select...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 19, 2009 at 5:29 pm
Yeah - that doesn't work in 2005. It might work in 2008 - but I wouldn't count on it.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 19, 2009 at 1:47 pm
oraculum (8/19/2009)
The problem is that 75% of that 'allocated'...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 19, 2009 at 10:49 am
Thank you for the feedback - I am sure it will help someone down the road.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 19, 2009 at 10:39 am
SQL Server will only release memory back to the OS when the OS needs that memory. On dedicated SQL Server machines - that will never occur. If you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 19, 2009 at 7:56 am
Jeff Moden (8/18/2009)
Heh... stiffed again. As soon as they get their answer, they're off until the next time they need help.
And you expected something different? Isn't there a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 18, 2009 at 8:06 pm
I have not done so myself, but I believe Litespeed will integrate with TSM. AFAIK, SQL Server native backups do not integrate natively with TSM.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 18, 2009 at 2:14 pm
bheinson (8/18/2009)
Fixed!
What was the problem? It would be helpful for anyone else who has a similar issue to know what you had to do to fix this problem.
thanks
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 18, 2009 at 2:11 pm
If I was building this system, I would not be building it on SQL Server 2005. I would be building this on SQL Server 2008 and implementing filestream access...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 18, 2009 at 1:58 pm
SQL Server will allocate memory up to the max memory setting and keep that memory. It does not release the memory. What you are seeing is normal behavior.
On...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 18, 2009 at 1:20 pm
Execute sp_help sysdtspackages90
Shows us that the primary key has been defined on the following columns: folderid, name
That should uniquely identify the row - which should also uniquely identify the package.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 18, 2009 at 1:14 pm
The question I have would be why do you feel it is necessary to shrink the log file?
In most cases, this is due to not having regular transaction log backups...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 18, 2009 at 11:40 am
It will only be a problem if you have 8 separate 1-core processors on the machine. I doubt that very much and would think you either have 4-dual core...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 18, 2009 at 11:24 am
Viewing 15 posts - 4,651 through 4,665 (of 6,676 total)