SQL!$@w$0ME (4/15/2016)

---

Hi guys,

I get this error after changing sql server service account from LocalSystem to a domain account (SQL 2008).

"Windows kernel object 'Global\SQL_90_MEMOBJ_MSSQLSERVER_0' already exists. It's not owned by the...

for multi subnet clustering see these links

https://msdn.microsoft.com/en-us/library/ff878716.aspx

https://msdn.microsoft.com/en-us/library/hh213080.aspx

alter the log shipping configuration to disconnect users during the database restores. Its not an error you're seeing, you've told LS you don't want to disconnect users. When the connections...

there are no PoSh cmdlets to control logshipping, logshipping is handled by SqlLogShip.exe.

What you could do is use PoSh to execute the TSQL scripts used to enable LS, but then...

Mad-Dog (4/13/2016)

---

Hi,

I've SQL Server 2012 STD and SQL Server 2014 STD and i need to implement some kind of DR or HA to it so i can reduce the load...

I've been required to backup dev databases before now, it depends on requirements

AlexSQLForums (4/14/2016)

---

Hi Everyone

I have a 2 TB Production db in AlwaysOn synchronous auto failover mode.

I have a 600GB(230 million rows) table which I would like to move to it's own...

8adger (4/13/2016)

---

Hi,

Thanks very much for your reply. What you suggest is essentially what i have done.

I have configured a number of availability groups on Server A and they are...

8adger (4/12/2016)

---

Hi,

If I have Server A and Server B and want to use them both like active active sql clusters but with Availability Groups so not true SQL clusters do...

tcronin 95651 (4/14/2016)

---

THought I had this right but here is where I am stuck.

Built active passive 2014 Ent Edition Cluster which seems to be fine.

Added a stand...

Nested roles can be a pain for this exact reason, at least you've found the issue

there is a retention period defined for the location where the primary writes backups and also defined for where the secondary copies the files too.

On the Primary

exec sp_help_log_shipping_primary_database @database =...

does the login own the database by any chance

select suser_sname(owner_sid), name

from sys.databases

where database_id = db_id('yourdb')

Yes, It's unique to the instance and used to encrypt objects within the instance

gaurav_ghiya (4/12/2016)

---

2. Do I...

you set [yourdb] and the user name string before executing?