Viewing 15 posts - 1,951 through 1,965 (of 9,253 total)
romanoplescia (7/3/2015)
I have a question about whether something is possible. I've started working at an organisation that has a sql 2005 cluster with a named instances on it, lets...
July 6, 2015 at 3:45 am
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...
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
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...
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 😉
July 2, 2015 at 11:00 am
has the account been trusted for delegation?
July 2, 2015 at 5:00 am
ItsDaveTime (7/1/2015)
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...
July 1, 2015 at 9:06 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...
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...
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...
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...
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...
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...
June 30, 2015 at 8:58 am
Viewing 15 posts - 1,951 through 1,965 (of 9,253 total)