The licensing of the backup server has to be identical to the licensing of the production server because, if you failover, it will be doing the same processing as the...

Oracle's support forums:

http://metalink.oracle.com/

Not as much fun, but good info.  I like orafaq, also.

Greg

I sure thought I pasted the url.  Oh well, here it is:

http://support.microsoft.com/default.aspx?scid=kb;en-us;827448&Product=sql2k

Greg

Here's where to look:

http://support.microsoft.com/default.aspx?scid=fh;%5Bln%5D;LifeSrvr

Greg

Try this Knowledgebase article.  It contains a workaround.

Greg

Sorry I didn't elaborate.  Your query needs to check for the existence of a match between the two tables.  The WHERE clause should look like this:

FROM DTS.companies d

WHERE NOT EXISTS...

Joan,

The Source tab is the correct place to write the query.  Try qualifying the table names with the database and owner like this: database.owner.table. 

You didn't say so, but I'm assuming the...

So, are you saying that when you import the data, the primary key contraint goes away or the values for the columns that make up the primary key aren't imported?

By...

Use the Date Time String Transformation option of the Transform Data Task in DTS.  See "DTS Transformations" in BOL.

Greg

I assume you're using the wizard.  Are you dropping and creating the destination table each time?  Can you post the table schema indicating the primary key?

Greg

If your recovery model is set to "Full Recovery", which it must be to do log backups, SQL Server will automatically truncate the inactive portion of the T-Log when you...

John,

You don't have to backup the logs for all the databases on the same schedule.  Backup the logs for the two busy databases more frequently than the others. 

As for...

Make sure all objects are owned by the database owner (dbo).  If the logon ID associated with the current connection doesn't own the table in the Select statement, SQL Server...

Standard Edition can use up to 2GB of memory so, if that's your only concern, Standard would meet your needs.

Greg

Yes.