Viewing 15 posts - 20,146 through 20,160 (of 26,490 total)
Paul White (6/30/2009)
Lynn Pettis (6/30/2009)
If all three instances try to go to max memory levels, then yes it is more than the physical memory in the server.
Good post. Just...
June 30, 2009 at 9:18 am
Paul White (6/30/2009)
Lynn Pettis (6/29/2009)
Jeff Moden (6/29/2009)
Lynn Pettis (6/29/2009)
And that will work until the SQL Server 2000 system table "views", like sys.syscolumns, go away in a future version od SQL...
June 30, 2009 at 9:00 am
Paul White (6/30/2009)
Lynn Pettis (6/30/2009)
June 30, 2009 at 8:55 am
Slight problem with the code you provided. The table, tblGRINMaster, doesn't exist in the post. To really try and help, we need this table along with some...
June 30, 2009 at 8:39 am
GilaMonster (6/30/2009)
Lynn Pettis (6/30/2009)
GilaMonster (6/30/2009)
June 30, 2009 at 7:35 am
I want to thank you all for looking. I personally haven't run into this kind of issue on any of the servers I have managed in the past 12...
June 30, 2009 at 7:28 am
GilaMonster (6/30/2009)
Lynn Pettis (6/29/2009)
My only problem is 30 years of experience...
June 30, 2009 at 7:20 am
Okay, I'll admit it if I am wrong, but I'd really like a few others opinions on this one please.
My only problem is 30 years of experience just has my...
June 29, 2009 at 11:44 pm
hi_abhay78 (6/29/2009)
Even if you add 100 GB of RAM it...
June 29, 2009 at 11:37 pm
As I said, a guess. I'd lower the max memory requirements for the three instances to a total of 6 GB (2 GB each) leaving 2 GB RAM for...
June 29, 2009 at 11:09 pm
So, you are saying that the only two accounts/groups with sys admin rights to your server were the Builtin\Administrators and sa, correct? First, as a general rule, you shouldn't...
June 29, 2009 at 10:58 pm
Okay, so when do I get everything else I asked you for, you know, the sample data, expected results based on said data? If you want help, you have...
June 29, 2009 at 10:46 pm
What's wrong with just doing this:
SELECT CustomerID, CompanyName FROM Customers
June 29, 2009 at 9:29 pm
A guess? You are overcommitting your memory. You probably should allocate more than 2 GB to each instance as that will total 6 GB and leave 2 GB...
June 29, 2009 at 9:09 pm
klnsuddu (6/29/2009)
Thanks for all your help...and one more question: does we need to give the backup path as
\\VirtualserverName(instead of Node name)\Z:\logshipping_backups_out in Log shipping wizard backup settings page?
The...
June 29, 2009 at 9:03 pm
Viewing 15 posts - 20,146 through 20,160 (of 26,490 total)