Viewing 15 posts - 1,951 through 1,965 (of 9,244 total)
Arestas (7/5/2015)
Iam geting the following error when creating a endpoint (that will be used for allwayson)
The Database Mirroring endpoint cannot listen for connections due to the following error: '10049(The...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2015 at 3:43 am
personally I'd log ship it over and break the LS plan once I was ready to move to 2012, how large is the database in question
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2015 at 11:40 am
are you wanting to synch the whole database from 2005 to 2012, if so, replication is definitely not the best way to do this.
Either mirror the db to the 2012...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2015 at 11:09 am
sreenubabu.s (7/2/2015)
Can you please provide Stairways links ?
see my first post in this thread on page 1 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2015 at 11:00 am
has the account been trusted for delegation?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2015 at 5:00 am
ItsDaveTime (7/1/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2015 at 10:12 am
nzone7x (7/1/2015)
Can someone explain how client application access works? I understood the active/passive model, but active/active/active/active is a fog in the mirror to me.
Each clustered instance uses its own...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2015 at 9:06 am
you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2015 at 7:54 am
It's SETSPN not Getspn or any other variant 😉
SETSPN -l should be run against the account the sql server service runs under, I'm assuming you know how to find this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2015 at 4:56 am
Chitown (6/30/2015)
How and Where would I find this Log Ship Directory?
You can find the backup folder\share in use by using the following query run against the primary server, look at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2015 at 4:51 am
Can you post the output of this please
RESTORE FILELISTONLY
FROM DISK = 'C:\Extract\REZ_db_201506240733.BAK'
The problem you have is the fact you're specifying the same file multiple times in the MOVE clause
RESTORE DATABASE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2015 at 1:24 am
SQL-DBA-01 (6/30/2015)
Any reason why the TDE does not turn the is_master_key_encrypted_by_server value to 1. The column in table "databases" database.
Is there anything special to be done to get...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2015 at 1:11 am
sreenubabu.s (6/30/2015)
Do we need another node (3rd node) for Automatic fail-over for AO HA Group ? or can we...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2015 at 10:57 am
Chitown (6/30/2015)
LS Backup job isn't running. Copy and Restore jobs are running fine.
Ok, now we know where to target our efforts
Chitown (6/30/2015)
Both Instances are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2015 at 8:58 am
Please post the output of this powershell query, substitute VERSION.INSTID for your sql server version and instance name
Get-ChildItem "hklm:\software\microsoft\microsoft sql server\mssqlVERSION.INSTID\mssqlserver\supersocketnetlib\tcp\" | ForEach-Object {Get-ItemProperty $_.pspath}
so if you're using sql server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 30, 2015 at 8:35 am
Viewing 15 posts - 1,951 through 1,965 (of 9,244 total)