Viewing 15 posts - 1 through 15 (of 164 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...
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...
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...
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,...
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...
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...
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...
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...
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,...
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.
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
from there you should...
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.
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...
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...
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...
September 25, 2008 at 1:07 pm