Viewing 15 posts - 5,911 through 5,925 (of 9,241 total)
You must set max memory otherwise SQL server will grab everything, or at least try to.
What values do you have set for the instances installed?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2012 at 7:40 am
can you supply any more info on the cluster setup?
have you checked the logs for further info?
have you ensured that all shared disks are presented to the nodes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2012 at 7:29 am
Kennedy.Parker (3/4/2012)
"No" because there have been no advances in data page storage structures/inernals over the last 10 years (for the sql 2000 datatypes anyway)?
There have been changes in data storage...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2012 at 4:59 am
are you referring to switching roles in log shipping, this is detailed in Books Online
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 5, 2012 at 4:53 am
kilkenny (2/27/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2012 at 11:27 am
i could be wrong but i think the required .NET components are missing with the Express edition installation.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2012 at 10:59 am
not sure about the Realtek chips but the Broadcom NICs could almost definitely take advantage of the Broadcom network control suite. Check the driver downloads for your server models and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2012 at 10:38 am
Yes, that would be correct. In future you may want to post in the SQL 2008 forum 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2012 at 3:35 am
newbie_DBA (3/3/2012)
can i perform this command on a live DB with no issues? and i should run it on the principal/mirror or both?
This should be dynamic, execute this on the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2012 at 3:27 am
Kennedy.Parker (3/3/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2012 at 3:01 am
NIC teaming is a function provided by the NIC manufacturer via a software interface. What brand\model of NICs do you have installed?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2012 at 2:54 am
GilaMonster (3/4/2012)
If you're not sure where to look, maybe consider getting someone in to look into the problem for you?
Agreed, all we have at present is an assurance the hardware...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 4, 2012 at 2:51 am
gmcrouch (3/3/2012)
rows are between 113 and 153 Rowsthats not to many right?
That's still excessive, what size are each of the log files physically?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2012 at 5:38 pm
run DBCC LOGINFO against each database and check the number of rows returned for each, post back here if you can.
It would also be advisable to check the configuration of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2012 at 11:52 am
sqlfriends (3/1/2012)
What is the beter route for me?
1. On the new box, install SQL server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2012 at 11:48 am
Viewing 15 posts - 5,911 through 5,925 (of 9,241 total)