Viewing 15 posts - 1 through 15 (of 165 total)
We have just migrated our development and test environment to virtual. But we still follow the hardware configuration as how we did previously; OS and binaries are different from data...
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
March 3, 2011 at 7:02 am
I have had the same problem with my SQL Server 2005 Standard Edition. We have contacted Microsoft and finally Microsoft said it is an issue with memory leak for SQL...
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
March 3, 2011 at 6:55 am
it is not going to be a side by side migration. We are trying to have a named instance of SQL 2008 on the default SQL 2005. Since the migration...
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
January 15, 2010 at 12:58 pm
Sorry about the confusion. Nodes are still going to be 2. No changes on that. We are adding another cluster actually. So, no problem there.
As for the Upgrade Advisor,...
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
January 14, 2010 at 8:14 pm
Lynn, Carolyn, Steve and Gila......Thanks a million for your reponses.
The problem i have here is this one systems is not driven by the DBAs. There is a specific application...
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
December 21, 2009 at 9:01 am
The DR server will not be for application server. It will be used as Reporting server which has its own SQL instance with no interaction with Production server other than...
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
December 21, 2009 at 7:04 am
Why not? There should be a set schedule in every company to do this. We have Production boxes in Active/Passive but once a week, we are given a window (Saturday...
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
September 14, 2009 at 1:22 pm
In our environment, we have it totally in a separate drive. If your case is the same, you should consider the same drill. Another thing to ponder is to know...
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
September 14, 2009 at 12:49 pm
Nevermind, I got it myself...
I will post the complete query...perhaps will help someone who has similar issue.
Run this first:
CREATE LOGIN ABC WITH PASSWORD = 'ABC#123',
DEFAULT_DATABASE = XYZ,...
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
November 12, 2008 at 1:49 pm
Looks like you never configured the server memory. Allocate them as I have said above and you should be having an optimized server.
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
October 30, 2008 at 2:44 pm
I think you are talking about min/max server memory which you do from sp_configure. try the following and see what you get:
sp_configure ' show advanced option', 1
reconfigure
sp_configure
from there you should...
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
October 30, 2008 at 9:58 am
Well, since there is no way other than loading the scripts in the server itself, I shall try it then.
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
October 30, 2008 at 9:50 am
What I meant was like when you want to see if there are failed logins in the logs, you basically go to the server and then right click properties. From...
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
October 30, 2008 at 9:23 am
Thats good to know. But even when I did your way and my way, after running sp_configure to see the changes, they are exactly the same. How can we really...
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
October 17, 2008 at 12:23 pm
Exactly!, I have a view as table name. But I have spoke with Microsoft regarding this and they accept that this is a bug in SQL which they are not...
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
September 25, 2008 at 1:07 pm
Viewing 15 posts - 1 through 15 (of 165 total)