One more thing to add is that node 4 has an error with AG synchronisation
can this be a factor with the job?

I apologize if unclear 🙂
The job is set up on the primary node and replicated on the secondary nodes ( 4 of them ). It seems like we are getting...

Hello Ricky,

Thanks for the link !

JR

Perry Whittle (2/11/2015)

---

if the user exists as a member of the sysadmin role you do not need to map them into databases, they can do what the hell they like...

Thank you all once again for your inputs !

My dillema is that since our primary instance is not a static instance ( whereas databases are created via the application from...

CooLDBA (2/10/2015)

---

I'm not sure if I understand you correctly but if your apps constantly creating new databases, you have option to put it in your existing AG or create new...

Perry Whittle (2/10/2015)

---

johnnyrmtl (2/10/2015)

---

Perry Whittle (2/10/2015)

---

the whole point with AlwaysOn availability groups is you don't need shared storage. Put a 3rd node in the cluster on the remote site and...

Perry Whittle (2/10/2015)

---

the whole point with AlwaysOn availability groups is you don't need shared storage. Put a 3rd node in the cluster on the remote site and put a standalone...

I think one issue will be that there will be separate SAN's between the site 1 and site 2

So over and above the FCI on site 1 between 2...

Perry Whittle (1/21/2015)

---

johnnyrmtl (1/21/2015)

---

Thanks for the reply...and sorry for the confusion.

I need to propose a 2 server clustering / failover solution with SQL 2012 and it seems that the log...

Lowell (2/9/2015)

---

the users themselves are contained in the databases themselves,

if you are migrating, maybe you mean migrating logins to a new server via the ms proc sp_help_revlogins?

for an existing...

Perry Whittle (2/9/2015)

---

johnnyrmtl (2/9/2015)

---

Thanks for your response !

Just to clarify... I added a new server login on a new instance and I would only need to add this login to...

SQL login 🙂

So if database names are called *DBxx* and an existing user "ABC" would need to be a dbo of these.

Thanks for your response !

Just to clarify... I added a new server login on a new instance and I would only need to add this login to over 700 databases...

TheSQLGuru (2/6/2015)

---

Try this at your own risk. I have used it in the past, but pretty sure it was for single-file/filegroup databases and they didn't have filestream.

drop table #files

drop...