GilaMonster (7/29/2011)

---

Try several hundred times harder. It's also significantly more expensive. iirc $500 for the...

That one goes into my briefcase :-D:hehe::w00t:

GilaMonster (7/29/2011)

---

I'm expecting please...

In case you don't know about those (pardon my french).

Also this link is amazing : http://tinyurl.com/42ovvds

aurato (7/29/2011)

---

HowardW (7/29/2011)

---

aurato (7/29/2011)

---

Yeah the reason I posted the email was to see if you all here disagreed with the recommendation. I read it and wasn't convinced it was...

That means that someone did a restore on that database at that time.

If this is the DB you've lost data from then you're screwed, the data is gone and you...

Would do but I'd like...

Jeff Moden (7/29/2011)

---

Gosh... has anyone ever heard of a good reason to have two identically named SQL Server instances in the same Domain? My gut says there isn't one...

HowardW (7/29/2011)

---

aurato (7/29/2011)

---

Yeah the reason I posted the email was to see if you all here disagreed with the recommendation. I read it and wasn't convinced it was addressing...

No it doesn't

either the server is under immense stress or the hardware is failing.

Can't tell which without lost more investigation...

My admin says it's a really bad idea and so does our consultant.

So you have a full backup on the 26th?

data loss on the 27th?

DB is in full mode?

Never ran any type of log backup on that db since the 26th?

My main point is don't waste the space on model if not absolutely necessary (especially since you seem short on HD space).

And you don't need a restart to grow the...

Let's call mine plain luck.

The servername (@@servername is sql server) was the same.

Physical machine name / network name / SQL instance were all different.

I once had a network admin copy...

Correct so far (didn't read the link)

aurato (7/29/2011)

---

When it...

I still don't see any problem. Just to make sure just run this for all your dbs :

DBCC CHECKDB('PROD_DB') WITH NO_INFOMSGS, ALL_ERRORMSGS

Once we're past that we'll go to...