Seems to be more cost effective for us at the moment to go with the 16 TB iSCSI sans for now. If we need more space, buy another one.

I'd...

Hunterwood (3/17/2010)

---

EDIT: Lynn, now you were quicker than me!

The problem is that the column is a DATETIME and you can't use LIKE with DATETIME values.

Use BETWEEN or a combination of...

Jpotucek (3/17/2010)

---

SELECT * FROM FRATERNAL.CONTACTS WHERE MODIFIED_DT = '2009-10-06-12.22.15.008000'

returns 1 row

SELECT * FROM FRATERNAL.CONTACTS WHERE MODIFIED_DT LIKE '2009-10-06 %'

returns an error: No authorized routine named "LIKE" of type "FUNCTION"...

Right now, your log file is going to keep growing until it uses up all the available disk space. You really need to setup periodic (scheduled) transaction log backups...

Flat files would be smaller and faster to receive. It really comes down to preference. Not having had to work with XML files (yet) and having much experience...

I have to agree with the overall concensus, it depends. Personally, I'd like to learn more about .Net and SQL CLR programming. Problem is we don't use it...

I always thought that's how things were done, if it worked its production else it was a test. 😛

They were looking at 185,000 for a dedup backup system, purchase a 16 TB iSCSI San for for 35,000 for storing backups before dumping to tape.

Like I said, maybe when...

Hate to break it to you, but that is precisely the point. You should be identifying the orphaned users within each database and fixing only those users. The...

If you look closely at my code, you will see that it only runs against those SQL Logins that are also in the system (comparing sys.database_principals and sys.system_principals).

Good to know that the pointers expire after a period of time. Is this configurable in your environment? I think I'd have some issues with blocks disappearing while...

jpSQLDude (3/16/2010)

---

If you mean Fail as in...

If the full backup taken at 1:00 PM is the first ever full backup, your t-log backup at 1:05 PM would fail as you wouldn't have a full backup from...

We were looking at such technology ourself, didn't buy it as it was too expensive and we are looking at 11 million to 16 million dollars in budget cuts for...

Slick84 (3/16/2010)

---

Hmm great.

So i've been reading SSIS does not support official SFTP file retrieval and that I have to use EXECUTE PROCESS task in SSIS to run a command...