Viewing 15 posts - 5,071 through 5,085 (of 9,241 total)
Follow these steps
enable and start LS copy...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 1:53 am
You'll typically install a new instance for a database when there are different security requirements or performance requirements.
Some applications such as Blackberry ES are best off ring fenced due...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 1:48 am
sierra4 (9/6/2012)
there were SAN issues on the server where E: and F: became unavailable.
we realized this when the log backups were failing.
now that the drives are back online this is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2012 at 1:42 am
Just out of interet why is hyperv installed, are you hosting VMs on this box too?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 3:50 pm
ramyours2003 (9/6/2012)
what is preffered node in sql cluster ?
The preferred node setting will attempt to locate the clustered sql instance group on a particular node or nodes. There is also...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 9:38 am
sjimmo (9/6/2012)
Freeing the buffers and cache will make EVERYTHING in SQL Server run slower.
Not quite everything. When you checkpoint a database and then run DBCC DROPCLEANBUFFERS it will only...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 8:15 am
ananda.murugesan (9/6/2012)
Mr. Perry Whittle, one final question1. What is the best pratices & procedure restarted both server principal & Mirror? if restart required.
Depends, are you rebooting both at sametime or...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 4:03 am
CHECKPOINT is a per database operation so you may need to run for multiple databases being attempting to free cache
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 2:42 am
It is generally taboo to ask a salary range at first interview, it portrays to the prospective employer you're just in it for the cash. Once at a second interview\offer...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 1:54 am
To manually fail to the mirror you need to execute
ALTER DATABASE <database name> SET PARTNER FAILOVER
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 1:41 am
lower the max memory and then raise it again
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 1:19 am
ananda.murugesan (9/6/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 1:17 am
soccer (9/4/2012)
Secondly, I installed SQL on the new server and added the node into the SQL cluster. The logs indicates clear...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 6, 2012 at 1:10 am
You can do, but i don't use it.
I, and I'm sure many others, create files based on date, much easier to manage.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 5, 2012 at 11:51 pm
jheim (9/4/2012)
Good article. Covered the basic configurations that people are "thinking about". Thanks.
Please do not forget to rate the article if you found it useful
jheim (9/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 5, 2012 at 5:04 am
Viewing 15 posts - 5,071 through 5,085 (of 9,241 total)