Do you then truncate the log file on disk or somehow delete it so you don't have duplicate data floating around?

Though, it still seems like it should be possible to...

Would it make more sense for me to use the DDL to look not at the login itself but the rights all logins have and if a login has a...

Steve Jones - Editor (8/14/2008)

---

A few of the 2008 exams went through a beta cycle, a few more starting soon.

...

Grab a 431 book. They're all similar, though I'd avoid the...

That is an interesting point, now how would I know when to end the trace? Would it time out after their connection ends?

Michael Valentine Jones (8/12/2008)

---

Sometimes it is necessary to have different servers because they have different maintenance windows for the applications.

One might have a downtime window of 0100-0600 on Saturday and...

Ah, good analogy.

Perhaps I can approch it from that stand point.

They don't have a seperate network file server for EACH folder on the network file share either.

There isn't an issue...

But how can I get them to understand that is my issue...

They just say "BUT THE VENDOR DATABASE IS SO IMPORTANT IT MUST HAVE ITS OWN BOX!!!!!"

To which I reply,...

SQL Server in VM's have some performance issues as I understand it (though that is changing as well).

Though I have asked about getting VM's setup to use for testing (for...

Oh about 3%....

Seriously, you can't even see it on the graph it is so close to the bottom.

Simply because we don't have that much traffic.

Most of our users look at...

Their main concern seems to be all about "stability" I can't seem to help them understand that having a seperate server is no more "stable" than having it on our...

Just so I'm clear, I should use SQL Profiler to run on the server itself and then filter by the login name and have it only capture data / trace...

OK, that makes more sense.

With the tape that is correct. I have it overwrite when it does the FULL backup of everything then it appends. Tapes change, it keeps...

Can you elaborate on the 1:1 instead of appending? I guess I thought you HAD to append T-log backups... apparently I am sorely mistaken...

Are you saying I would just...

Good point.

It sounds like I need to adjust my backups to backup to the hard disk first and THEN move them to tape via NT Backup or something?

I tried doing a restore headeronly from the tape drive witn NOUNLOAD thinking maybe the tape drive was taking forever to respond or something, but that process only took 1...