Are you backing up to disk? Are you appending or overwriting? If you are backing up to disk and allowing append, then the date/time of the backup file changes to...

Is anything else being backed up to those tapes?

-SQLBill

I would be in SERIOUS trouble if the autogrow didn't work and I had to expand my logs manually. I have my logs set to grow by 2000MB. And they...

What error log were those found in? Do you mean the SQL Server Log? If so, that's not an error log.

Reason I ask is that those aren't errors, they...

SJ,

That's a good point, but Wendy is accessing it from the same machine that it's installed on so the firewall wouldn't be used.

-SQLBill

One thing to remember...you MUST do a FULL backup after truncating the log.

As stated before, the truncating of the log breaks the 'chain' of log backups. Therefore any log backups...

Refer to the BOL, use the index tab and enter BACKUP DATABASE. That will explain how to write the backup script.

Then in Enterprise Manager, expand down to SQL Server Agent>...

Steve,

What kind of image (.extension) is it? Some .extensions are blocked by the people I work for (government). Knowing the type of extension will help me figure out if it's...

Nope, a DELETE like an UPDATE or INSERT is an 'all or nothing' transaction. If you kill the process, the delete has not finished (<>all deleted) so everything will rollback.

Your...

Sam,

The evaluation, developer, personal, and MSDE all install on XP Home.

http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp

Wendy,

Are you SURE you installed the SERVER and not just the CLIENT TOOLS? If you did install the...

It's used to identify UNICODE and is used with NCHAR and NVARCHAR.

Look in BOL under NCHAR and NVARCHAR.

-SQLBill

You might want to first figure out the missing records (11-11 to 12-15) and get that data into the final database.

Then do the comparison.

-SQLBill

You are backing up over a network. Does the SQL Server services (MSSQLServer and SQLServerAgent) run as domain accounts? Do those accounts have permission to access the destination?

-SQLBill

One other thing to check...in Enterprise Manager, expand down to your database. Right click on the database, select View>Taskpad. Scroll down on the right pane until you see the two...

Sukhoi,

No one ever said the use of a WHERE clause eliminates the use of the index.  Reread what Frank actually said.

Let's consider a basic index, like the one on a...