I figured it out on my own. Go into the publication that is failing and right click on it. Then click on Agent Security.Then click on Security Settings and...

Markus (1/10/2014)

---

Do a SP_WHO2 and see what SPID your restore is running then do a SP_WHO2 99 with 99 being the thread number... and keep hitting enter to...

Do a SP_WHO2 and see what SPID your restore is running then do a SP_WHO2 99 with 99 being the thread number... and keep hitting enter to see...

Good question. I haven't heard any rumors about it or a CTP for it... with SQL2014 just around the corner they may not be even doing one... not sure.

Also try and search for .mdf and .ldf files on your server and see if there are model.mdf and ldf on the server. Also, the system database files...

djackson 22568 (1/6/2014)

---

Markus (1/6/2014)

---

djackson 22568 (1/6/2014)

---

Markus (1/6/2014)

---

One area of movement will be the accelerated movement to SSDs. They are dropping in cost rapidly and I think we'll start seeing them...

djackson 22568 (1/6/2014)

---

Markus (1/6/2014)

---

One area of movement will be the accelerated movement to SSDs. They are dropping in cost rapidly and I think we'll start seeing them in more and...

One area of movement will be the accelerated movement to SSDs. They are dropping in cost rapidly and I think we'll start seeing them in more and more systems from...

I think what you are looking to do is decrease the retention timeframe.... from 72 hours to.... maybe 24 hours.....

Oh I agree... I agree.... Your results may vary... no doubt...

I just because the folks at companies I know are just about off of or totally off of...

djackson 22568 (1/2/2014)

---

Markus (1/2/2014)

---

It will be interesting to see what the XP marketshare is once Microsoft fully desupports it in 2014. Then, if a flaw is found how bad...

I use SQL Monitor. It does the basic stuff and is probably the least expensive to purchase.

I guess it depends on what you want to get out of the...

Michael Valentine Jones (1/2/2014)

---

SQL Server 2014 In-Memory-OLTP Tables do not support identity columns or foreign keys, so that puts them well outside what I would be willing to accept for...

If you have a domain ID that runs the SQL Server service that ID will need to be setup in the new domain... plus that ID will need to be...

Are any of the SQL Servers Clustered? If so... that is a much bigger process. I believe that Win2008/SQL2008 clusters cannot be moved to a different domain...