Viewing 15 posts - 6,136 through 6,150 (of 6,676 total)
Yes, 30GB is too much for SQL Server. I would recommend setting this to no more than 28GB and make sure the minimum is set to at least 1GB...
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, 2008 at 1:01 pm
masood24 (8/17/2008)
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 17, 2008 at 11:29 am
No, it is not necessary to get everyone out of the db. But, you need to make sure you have transaction log backups scheduled. How often you schedule...
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 16, 2008 at 8:02 pm
Use Add/Remove to remove a single instance. Instead of selecting to remove, select to change and you will be given the option to uninstall components.
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 16, 2008 at 5:42 pm
Oops - forgot the temp table, thanks Jeff.
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 16, 2008 at 3:56 pm
Yes, this can be done using an alias. Example:
SELECT t1.col1 AS t1_col1
,t1.col2 AS t1_col2
...
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 15, 2008 at 8:43 pm
And, just to make things interesting - in SQL Server 2008 they changed it to: ssms.exe
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 15, 2008 at 8:36 pm
You can check the aliases by using SQL Server Configuration Manager (which, I don't think you can use because of the WMI error you are getting).
You can also find out...
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 15, 2008 at 4:39 pm
Did you update statistics with full scan?
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 15, 2008 at 2:38 pm
This is very clearly spelled out in Books Online (BOL) under the topic default schemas. You cannot set a default schema for a windows group.
From Books Online:
If DEFAULT_SCHEMA is...
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 15, 2008 at 1:01 pm
Verify that the client tools have been upgraded to at least the same version as the server you are connecting to. My guess is that your client tools have...
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 15, 2008 at 12:57 pm
Let's try something else - verify the name of your instance for this server. Open the services applet, scroll down to the SQL Server instances, expand them so 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 15, 2008 at 12:22 pm
The only time I see the icon without a green arrow is when I am connected to a cluster or there is some issue with connecting to that server. ...
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 15, 2008 at 12:08 pm
rmaggio (8/15/2008)[hrThanks Jeff! Do I have to be logged in as anything special, or will my normal full access Windows Login suffice?
Shouldn't be a problem.
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 15, 2008 at 11:53 am
Well, I am at a loss here - the summary you showed does not show an instance being available on that system. The service pack cannot update what 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 14, 2008 at 10:55 pm
Viewing 15 posts - 6,136 through 6,150 (of 6,676 total)