Viewing 15 posts - 3,871 through 3,885 (of 9,244 total)
Marcia Q (3/2/2011)
Here's our setup:
SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2013 at 9:21 am
sqlmunkee (11/19/2013)
Do you really need the instance name and the port number ?
No, you dont.
use either
server\instancename
server, portnumber
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2013 at 5:21 am
sunny.tjk (11/18/2013)
The steps of the job are(1)start trace
(2)run the trace for 2 mins
(3)stop trace
??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2013 at 1:10 am
homebrew01 (11/18/2013)
My goal is to make best use of the 4 G ram that I have, and address the apparent Linked Server issues I am having.
As I said before then,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2013 at 11:52 pm
homebrew01 (11/18/2013)
boot.ini has /PAE, but not /3gb
With your current OS and app config putting /PAE into the boot.ini has done little more than force you to reboot the server 😉
Windows...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2013 at 4:02 pm
homebrew01 (11/18/2013)
Perhaps tomorrow I will reduce SQL RAM to 2.5 G, and add the -g700 setting, then restart.
If you dont have AWE enabled correctly and you set the -g700 startup...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2013 at 8:21 am
sstacy7 (11/17/2013)
How do you delete
Are you referring to cluster nodes?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2013 at 5:25 am
homebrew01 (11/10/2013)
I rebooted this morning.I thought AWE was set correctly. I'll have to read up on it ... forgot the details.
I just ran:
sp_configure 'awe enabled', 1
RECONFIGURE
You also need to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2013 at 5:15 am
rajeshjaiswalraj (11/15/2013)
before my database was in standby i make it online using
restore database <name> with recovery
but now again i want to put my database in standby
can any one...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2013 at 2:54 am
SQL_Surfer (11/17/2013)
can't take compressed backup on 2005...what are other options? because other dbs are pretty similar in size.
install the trial version of Litespeed and use that to compress and move...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2013 at 2:50 am
The failover tab details whether fail back of the resource occurs to a preferred node. It also specifies that if multiple failures occur within a given time period the application...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2013 at 8:53 am
This link details the policies tab
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2013 at 6:31 am
If you do join a clustered instance to an AO group you will not be able to use automatic failover.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2013 at 12:53 pm
javirsantos (11/15/2013)
I roll online and instances discontinuous work well.
When you uninstall CU1 fails...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2013 at 10:06 am
You should still be able to move it using the commands above, works just fine for me
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2013 at 1:54 am
Viewing 15 posts - 3,871 through 3,885 (of 9,244 total)