Please don't ask for copyrighted material that is for sale. This is illegal and immoral. Invest in your career if you want the resources.

Not a bother at all, and good questions.

Here's how I see things:

1. If the Oracle DB connects to your SQL Server, 1 CAL needed. If SQL Server connects to Oracle...

I would worry about corruption, but do any of these help?

http://blog.sqlauthority.com/2007/08/02/sql-server-fix-error-945-database-cannot-be-opened-due-to-inaccessible-files-or-insufficient-memory-or-disk-space-see-the-sql-server-error-log-for-details/

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/01/22/error-945-severity-14-state-2-database-mssqlsystemresource-cannot-be-opened.aspx

Sounds like a good plan.

Did you allow for the backups themselves? They take space. Typically I would be moving the fulls to tape (or another server) ASAP, and then I'd...

GSquared (3/2/2012)

---

a) There are a lot of people looking for work, many of whom have valid credentials/qualifications for the field they work in, and many of whom have been a...

Then they didn't want to be there and they weren't good fits. Or you're...

TravisDBA (3/2/2012)

---

...

Actually, I am more interested in going to 2012 for the "Contained Databases' feature than the "AlwaysOn" feature because remapping logins/users and permissions has always been a pain...

16 cores meaning a 4x4 or are they more dense than quad cores? If you have more...

I hesitate to post the kb, because I don't believe in it, but there is a trace flag that bypasses the network drive check.

I don't have a 2000 instance to...

Correct, this is a security issue. The service account is the one that gets them ACL'd. You need to change that, carefully, to allow an admin to see them.

Make...

Shut down all the SQL programs. As Elliot said, if you can't do that, you're not prepared for the exam, or you should do some research.

I'd be happy to help,...

L' Eomot Inversé (3/1/2012)

---

(1) someone with a decent CS education, a decent brain, no serious handicaps (blindness, deafness, dislexia), and willingness to put hard effort into learning should be able...

siva 20997 (3/1/2012)

---

This is my last post only becuase this thought hit me and I am wondering how many have got such situations

Lets Say we have a customer with say...

I agree with what Gail has posted. You are trying to develop situations that aren't the same to justify not purchasing CALs or socket licenses.

That being said, I'd welcome you...

It's not about IIS, it's about multiplexing. If you write a middle tier that allows multiple people to access data on SQL Server simultaneously, then you are mutliplexing and you...