Viewing 15 posts - 2,896 through 2,910 (of 9,241 total)
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
For clarity here's the orignal question
zedtec (9/26/2014)
I just wanted to ask, if mirroring is set up over a WAN and the internet connection between the sites goes down how does...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 6:59 am
kevaburg (9/26/2014)
What happens if I perform a backup over the network and I have an outage?
It will fail and you'll need to restart the backup from the beginning
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 6:09 am
zedtec (9/26/2014)
Hi,I just wanted to ask, if mirroring is set up over a WAN and the internet connection between the sites goes down how does this affect database mirroring?
depends on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 26, 2014 at 5:20 am
Viewing 15 posts - 2,896 through 2,910 (of 9,241 total)