Viewing 15 posts - 2,896 through 2,910 (of 9,244 total)
solomon.jernas (10/2/2014)
HIHow to apply patches in Sql server 2005 Active/passive cluster ,what are the steps need to be follow..
We will be initiate production server..
Please anyone help to us..
Regards,
solomon
Which patch(es)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 2, 2014 at 2:38 am
you dopn't set a default schema for a windows group, look at the default schema for the user
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 2, 2014 at 2:35 am
DudeGuy (9/30/2014)
The problem ISN'T NETWORK
using conventional mirroring, the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 2, 2014 at 2:34 am
sqlfriends (10/1/2014)
Just list of the above.For that, don't I need to create the users in the database?
Thanks,
Yes, but do the users in question need to create database users?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2014 at 10:32 am
sqlfriends (9/30/2014)
There are 4 GIS people who knows SQL and often do queris and import/export tables, create tables/views/sprocs etc in the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2014 at 10:18 am
great, thanks for replying as this may help others in the future 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2014 at 5:31 am
sej2008 (10/1/2014)
yes I have given administrator the permission to access my shared folder on primary server.
The administrator has nothing to do with it, when a service runs as local system...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2014 at 5:15 am
Just the instance name is required not the full servername
/QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=Autotest
/SQLSYSADMINACCOUNTS='Domain\administrator' /SAPWD='Test@123'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2014 at 8:44 am
sylvain.desmarais 74280 (9/30/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 30, 2014 at 8:41 am
With modern R10 controllers you actually get more for your buck. They are able to spread requests to multiple disks in the array to share the workload. This has a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2014 at 4:18 pm
The listener always connects to the primary replica and based on the user connecting dictates the view they will see
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2014 at 1:01 pm
DavidB 36561 (9/28/2014)
I had checked DBCC OPENTRAN (Distributed was 0 but very large number Non distributed) and then dm_exec_sessions first and there were no long running transactions and no-one...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 29, 2014 at 12:59 pm
samalex (9/28/2014)
I've made similar restores without issue with just running sp_dropserver and sp_addserver to fix the server name
I would say you've been lucky up til now
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2014 at 10:18 am
sej2008 (9/27/2014)
I am doing log shipping on same machine between two instances using Localsystem account for sql agent service on windows server2008 R2
OK got this so far
sej2008 (9/27/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2014 at 5:12 am
samalex (9/27/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 28, 2014 at 5:04 am
Viewing 15 posts - 2,896 through 2,910 (of 9,244 total)