I figured it out. Thank you.

I have attached the error below...

dropping the article doesnt need snapshot generation. adding the article to existing publication doesnt need to generate the snapshot for all articles in that publication. you can just run the...

As once the database has been migrated to 2014- can i take the backup of 2014 database and restore to 2008?

any more suggestions??

If resource fails attempt to restart on the same node setting is on. I guess it's default setting. We are working with msft team and changed few tcp chimney settings...

Any suggestions??

Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64)

Copyright (c) 1988-2008 Microsoft Corporation

Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

If we disable sa login on the server and all the database owners are sa. Do we see any conflicts in the reboot of the machine or restart of the...

K. Brian Kelley (4/2/2014)

---

Since you don't know what all was done, consider this server compromised (permanently). That means the OS and means the attacker could potentially come back in. Therefore,...

george sibbald (4/2/2014)

---

I am sure you have already thought of it, but change the sa password or disable sa, turn off xp_cmdshell if you don't need it. By having sysadmin...

Yes. we know the root cause of how they got into the server- our networking engineer made some network port changes in ipconfig table so that the sql server is...

I am not sure about commvault backups. But most of the third party tools have their own encryption methods. Please check the commvault software documentation.

muthyala_51 (3/11/2014)

---

425 GB max memory setting.

Given the fact you have a lot of CLR and ext stored proc, etc i would lower the max memory setting a little. Monitor the...

500 GB RAM. 425 GB max memory setting.