Snoopy,

What point are you trying to make?

In the 'note' portion you only highlight PART of the comment.

This is correct:

database size for SQL Server 2000:   1,048,516 TB³

The 'note' discusses a DIFFERENT...

Reindexing will cause your database to have extra free space (the space freed by the reindexing). Shrinking gets rid of excess free space. So, having said that, which do you...

Have you tried running DBCC UPDATEUSAGE??

-SQLBill

It depends on what database id 2 is. It might be the MODEL database.

When you restart SQL Server, TEMPDB is rebuilt from scratch. How are new databases built? From the...

I have a database which is 170+GB in size. I do a Full backup once a day, a Differential once a day and several Transaction Log backups during the day....

I suggest checking your VB code. It appears to be in the way the Client-side displays the value.

VB might have a default that eliminates the trailing zeros.

Remember, SQL Server (or...

Being that MSDE and CE were not options in the answers, you can ignore those. Answers are part of the question. There may be other answers, but if they aren't...

Thanks to both of you (AJ and Vladan) for pointing out to me that if you use the alias in the UPDATE you can use it in the SET.

Do we...

There are lots of things you can do to 'shrink' the tempdb. But all you really need to do is stop and start the SQL Server services.

That causes TEMPDB to...

I'd like to add my comments to Peter Yeoh's.

3rd party vendor products can be awesome. As Peter points out, vendors usually add features that may improve upon the original. Consider...

A smaller backup size is usually due to using 'compression' when backing up the database.

Are you using third-party software to do your backups?

-SQLBill

Let's clear something up here.

The backup is not JUST the actual data!

A backup is a file that is used to restore the data back to it's status at the time...

Interesting AJ! If you read the BOL reference I posted, it specifically states and shows by example that the syntax won't work.

Guess that's one of the 'flukes' in SQL Server.

-SQLBill

#1 SQL Server Backup commands work. They will ALWAYS work with SQL Server. PERIOD.

#2 There is 3rd Party backup software that works just fine (for now) with SQL Server. They may...

Can't do it.

SQL Server does not allow an alias in that position of the SET command.

You can double check me. In BOL, use the Index tab, enter Update, Update (described)....