Personally I'd recommend using log shipping. Take a full copy of the database, restore it to your remote location but do not recover the database (WITH NORECOVERY or the second...

Couple of questions:

1) You are writing to a UNC path I assume

2) Are you using a SQL Server Maintenance Plan

3) This is SQL 2000 I assume?

4) Are you using a...

That's also the safer way to do it. There are ways you can backup to a network share, but avoid the urge to do it directly. That will lengthen the...

Actually I didn't word my comment about the use of C$ properly. What I meant to say is - don't use it. That's a dangerous security habit.

Could be an MDAC version issue - I'd check those versions. I'm assuming that the client versions of Access are the same patch level?

It could also be a client security...

Sigh. This is extremely difficult to explain.

In general, you have it correct. In Oracle there is a schema that is associated with a login. You can not change ownership of...

Thanks for correcting my spelling. I feel stupid now, especially since I brought it up

So how many of us know what the mathematical terms "google" and "googleplex" represent? (yes, they are real mathematical terms)

Yup, WITH MOVE works for everything except moving TempDB, which is moved with the ALTER DATABASE statement.

One caveat with TempDB - make sure Model exists before you attempt to move...

I would add that you should restore the system databases FIRST, and I would agree with the order you suggest.

Be aware that once you restore Master, you may see...

I assume the torn pages were on the E: partition only. If you keep the drive label the same, restoring to the same path from the last good backup setup...

Log shipping should work without a problem, although mirroring probably will generate some difficulty. I haven't done either, although given the way log shipping works ( a log backup copied...

Ah. With 2005 they've changed the certification paths. MCTS is the base technology test for any additional certifications. If you wanted to get the profession database developer certification, there's 2...

In order to use table names or columns as a parameter in a query, you have to build a string and execute as dynamic sql. E.g.:

Declare @SQLStatement Varchar(100)

Declare @tablename varchar(20)

set...

If you go through the items covered at http://www.microsoft.com/learning and feel comfortable with it, you should be OK. Measureup.com has an online test simulator that is pretty good. As...