Viewing 15 posts - 3,706 through 3,720 (of 6,676 total)
You can also download and install Performance Dashboard from Microsoft.
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
June 28, 2010 at 2:17 pm
From Object Explorer - right click on the server and select Activity Monitor. Or, you can launch Activity Monitor from the toolbar button when the server is selected.
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
June 28, 2010 at 1:38 pm
WayneS (6/26/2010)
If you have both 2005 and 2008 servers, do NOT use SSMS...
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
June 26, 2010 at 6:41 pm
I believe the issue you are running into is a known issue - called the double-hop issue with Windows authentication.
To get this to work and allow Windows to authenticate to...
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
June 26, 2010 at 2:18 pm
Yes - that is correct. With your current configuration SQL Server can only use 2GB of 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
June 24, 2010 at 7:06 am
On x86 (32-bit) platforms, applications are limited to a maximum of 2GB of memory. To get above that limitation you have to enable PAE and AWE. However, that...
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
June 23, 2010 at 11:26 pm
I don't think it is - but I have to ask why you would want to? What problem are you trying to solve by doing this?
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
June 23, 2010 at 7:06 pm
How big are the databases being backed up?
Where are you seeing the in progress status? Is it the job viewer? If so, have you tried refreshing the job...
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
June 22, 2010 at 7:54 pm
Hmm, not changing the DATEFIRST here - but I seem to get Sunday 😀
Declare @currentDate datetime
,@sundayDate datetime;
...
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
June 21, 2010 at 2:43 pm
The only thing I know of in SSMS that would come close to what you are looking for is templates. You can create a template with placeholders for your...
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
June 21, 2010 at 2:30 pm
If you are asking about managing transaction logs - read the article I link to in my signature. If you are asking about the error logs, then it depends...
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
June 21, 2010 at 2:24 pm
It won't matter what you do or how you set this up. SQL Server 2000 Standard Edition is limited to 2GB of memory. Enable PAE, set AWE -...
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
June 21, 2010 at 2:15 pm
One thing you can check is whether or not replication was setup on that database. It might have been setup and removed, but not completely.
I also suggest you read...
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
June 21, 2010 at 1:57 pm
Did you put .bak or just bak for the extension? If the former, this is your problem. You can open the maintenance plan, open the backup task and...
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
June 19, 2010 at 3:10 pm
That would depend on the system resources available. I would start by trying to reduce by 50GB at a time. If that takes too long, go with smaller...
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
June 18, 2010 at 4:19 pm
Viewing 15 posts - 3,706 through 3,720 (of 6,676 total)