SQL Server 2000 - During a full backup, all committed transaction are included in the backup as of the conclusion of the backup. Example:

7:00pm - Full backup Starts

7:14pm - insert...

The other side (Disclaimer, I'm not married)

SELECT    'Married?' =

      CASE

         WHEN Married IS NULL THEN 'Ambiguous'

         WHEN Married = 'NO' THEN MAX [Free Time]

         WHEN Married = 'YES' THEN .5*(Disposable income)

      END

FROM...

We use LiteSpeed and i couldn't be happier with it. It works great, turns a 47GB backup into a 14Gb file and takes a lot less time to perform the...

I don't see Access in your original post. It sounds like an MSDE error. Sorry I can't help any more. Sounds like you need to contact Interland.

Are you using MSDE?

The Event Log on either (or both) Windows servers should have one or more entries that will describe what was going on to cause the failover. Check the Event Viewer....

Yes, it will wait until the FULL is finished before starting the transaction log. From Books Online:

     The transaction log cannot be backed up during a Full database backup or...

Also, if you know in advance, you can create the table in its own filegroup, then do a filegroup restore when needed.

SQL LiteSpeed can do a table restore of...

There's a chart of which data types are converted implicitly, which require explicit conversion, and which are not allowed in Books Online. Look for Cast and Convert.

I always stop and start the clustered SQL servers (virtual servers) in Cluster Admin.

I think that a lot of the reasoning stems from the fact that AD is a JET based database (IIRC) and Jet and SQL Server don't play too well on...

Inside SQL Server 2000 by Kalen Delaney and The Guru's Guide to SQL Server Architecture and Internals by Ken Henderson are probably all you'll find discussing internals. There may be...

As to the holier than thou...

I don't know. We're talking about BASIC background knowledge necessary to do your job. Now, depending on your specialization, I can understand not knowing one...

That's a case where I would follow up and ask them about it. From my experience, they're probably an old hand who has worked with much older database systems that...

joshcsmith13, I hope you're joking, because otherwise you need to google SEQUEL and find out about the history of Structured English QUEry...