Like2SQL (7/31/2014)

---

We have a SQL Server located in India; We need to move all the DB's on that server to a server residing locally for various legal reasons. The Server...

Where you can't trust domains treat the servers like a workgroup and follow my guide at the link provided 😉

grkanth81 (7/31/2014)

---

HI guys,

I am having a LSAlert_Serv job and this job runs the system stored procedure sys.sp_check_log_shipping_monitor_alert. when this job is run I am getting the following error message:

Here...

annam.dba (7/31/2014)

---

Hi,

There is a requirement to one of our client to configure log shipping between two different domains, Is there any way is there ? could you please help...

Someone...

If you ran sp_help_religion on a 2008 instance and moved to 2012 the passwords would be lost due to the changes in encryption.

lkennedy76 (7/30/2014)

---

When they were created about a month ago, I used sp_help_revlogin. I scripted out the users on the old server, created on the primary node, used sp_help_revlogin to get...

😀 clearly those terms are confusing!

Whatever you set it to!!

Open sql server configuration manager on the server and check the acct in use for the sql and...

SQLSteve (7/30/2014)

---

Trying to get my head around a scenario

I have 2, 2 node clusters

PROD1(cluster 1) Clustered SQL instance1

PROD2(cluster 1)

DR 1 (cluster 2) Clustered SQL insatace 2

DR 2 (cluster 2)

I have...

No, it wont. It allows acces to a range of system catalogs

JeepHound (7/29/2014)

---

Somehow the sharepoint farm is still trying to connect so I can't get logged in single user. What method could I use to stop users from connecting when...

This link details the following

Technet: How to enable log shipping (TSQL)

---

To enable log shipping

2.On the primary server, execute sp_add_log_shipping_primary_database to add a primary database. The...

See this link

wouldnt hurt to try it with the databases read only, good luck