firstly satisfy yourself there is not good reason why the log file is that big. also check the growth factors and avoid percentage growth settings.

The shrink will not affect log...

me too, but who's complaining? 🙂

looks like your third party hosts are running some sort of third party backup, have you spoken to them?

do you use the transfer logins task to copy them across? that randomises the passwords.

logshipping will know which logs to apply but they must be available to it in the defined directory.

Personally I always do the initial full restore in norecovery and then allow...

New Born DBA (7/1/2014)

---

I completely...

state 5 is definitely invalid login.

striping the backup should help.

Grant Fritchey (6/30/2014)

---

george sibbald (6/30/2014)

---

if your system has been running stable for a few years with no issues, you are unlikely to hit new problems, and known issues and security...

I thought you might be when you mentioned 2000 and 2005.

SECURITY fixes are available during the extended support phase, caveat is you are on the latest service pack

if your system has been running stable for a few years with no issues, you are unlikely to hit new problems, and known issues and security fixes will still be...

only two?

you will have to go back to the original instance to do the scale out part, best to google the full process

190MB is low but you are not out of memory. As Gail says use those two perfmon counters, to see what else is consuming memory use process:private bytes:all instances. Run...