Viewing 15 posts - 3,526 through 3,540 (of 6,676 total)
This sounds very reasonable to me. With the increased size of the auto-growth, even if it grows out to 4GB again you won't have too many VLF's. Well,...
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
November 1, 2010 at 2:07 pm
It didn't happen by itself. It happened when log shipping was set up and the database was restored on that system.
You can't change it now without rebuilding log shipping....
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
November 1, 2010 at 7:30 am
Hi Scott,
You can see several examples of queries with inner joins and outer joins in the AdventureWorks database itself. Open the Views folder and take a look at the...
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
October 31, 2010 at 10:33 am
It's possible that the person who set this up created the data files using .BAK as the extension. You can validate what files are being used by:
SELECT * FROM...
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
October 30, 2010 at 12:30 pm
hydbadrose (10/27/2010)
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
October 27, 2010 at 10:39 pm
Brad, please start a new topic for this request. This is a very old thread and you'll get many more people looking at your issue if you start 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
October 27, 2010 at 6:59 pm
I am not clear on how you are trying to access the 'default' instance. What are you using to 'see' the instances on each node?
When you fail the 'default'...
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
October 27, 2010 at 6:58 pm
How are you determining that node b is missing SQL Server?
Are you able to failover the 'default' instance on node A to node B?
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
October 27, 2010 at 2:55 pm
Are you running SQL Server on x64 hardware?
Are you running an x64 version of SQL Server?
If so, have you set the max memory for all instances on that system?
If not,...
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
October 26, 2010 at 7:33 pm
On a side note - since you are on SQL Server 2008 you can implement a policy that prevents database names from having spaces - or any other special characters...
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
October 26, 2010 at 7:31 pm
When you install SQL Server on a cluster, the installer will install the across all nodes. The instance will then be active on only one of those nodes. ...
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
October 26, 2010 at 7:28 pm
Yes, you should always update the client tools to the highest version level (at least) of any systems you access.
So, if you access a server with SP3 installed - 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
October 26, 2010 at 2:43 pm
The answer really is 'it depends'. It depends upon what else is running at the time, how many CPU's you have, how much memory, what your IO subsystem 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
October 26, 2010 at 2:40 pm
You can also just remove sysadmin rights to the BUILTIN\Administrators group (after making sure you have another sysadmin login available).
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
October 26, 2010 at 1:57 pm
cjohn5552 (10/25/2010)
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
October 25, 2010 at 8:16 pm
Viewing 15 posts - 3,526 through 3,540 (of 6,676 total)