vishacad (11/24/2008)

---

one more thing folks, on the backup speed

It used to take 8hrs to backup the DB size of 300GB to a local drive and + 6hrs for copying it...

millsrustyk (11/21/2008)

---

We run audits daily on the "business integrity" of some parts of the data and send the relationships or mis-aligned data results to the Data Entry personal. This is...

While I know the economic issues are having some effect on the job market, I believe it's also related to end-of-year activities and new budget items and the like. I...

There isn't but isn't "!=" "old school"??? I haven't used it for about ten years! 😀

"Not in" will work. Don't use != but you can...

Something tells me there is more to the code than what you've posted. In...

Ever heard of Google?? Based on that overwhelming volume of information you provided...

You stated you wanted help to "recover from suspect mode"......The backup you are trying to restore, is it SQL 2000 backup...

Soory, I should've quoted this in my first post. The point...

There a plenty of threads opened with the phase "I've deleted my data but don't have a backup...

And be sure you have a recent backup BEFORE you run the deletes.

Never give your developers access to your production servers. That should be your responsibility. They develop and unit test. Somebody (you??) does a final test and promotes to production, period....

Your baseline is always the full backup restored first. Then each log is applied to the restored database, oldest to newest, up to the point you want to get to,...

drop database??? No seriously, add disk or archive data are really your only viable options (maybe cleanup any unneeded "temporary" work tables?). Obviously, archiving data is going to require some...

Speaking from a SQL 2000 perspective (I know which forum this is), I saw this once before. We had two clients at different version levels of the client tool (ODBC...