You can should be able to reset the initial size to 10GB, then use the SHRINKDATABASE function to shrink the file & reclaim free space.

Some advise against ever shrinking the...

You should also go into Local Users and Groups\Groups and delete the SQLServer* groups that the install creates. These can also cause new problems when re-installing after a failed...

It doesn't add up because the differentials contain CHANGED data, not just ADDED data. When existing records are modified, the modified pages make the diff backup larger but the...

This message means you can't connect to the instance.

1) Open SQL Server Connection Manager and Verify that SQLServer service is running on the server.

2) If you are trying to connect...

There are several good reasons to have a nonProduction SQL server on which you restore backups from Production.

1) If you do this on a regular basis, you'll be well-practiced in...

Cleaning up a failed SQL installtion can be a real bear, but sometime you can't reinstall until all traces of a failed installations are removed.

Here are some hints:

1) First...

For confirmed errors & corrections see KB968609

I stand corrected. Now why would a developer use anything other than a datetime to store a timestamp? It seems to lead to more complexity with no benefit.

I believe the datatime datatype was new with SQL 2005, so applications developed before that used various schemes for dates & times. While upgrade routines of recent versions...

I'm studying for the 432 exam and I'm getting this error when attempting the ALTER TABLE SWITCH statement.

The message suggests there is no index on the source DB indentical to...

Wow - it took me a couple of days in between othe tasks, but I finally finished reading the thread, and I feel the need to add my two cents:

-...

I'm studying for the same exam right now. I'm curious, what study strategies do & don't work for you? Here's some of my thoughts:

Actual Experience:

Everyone says...

For anyone who reading this topic who found something in the Training Kit that doesn't look right, the Training Kit book & Practice Tests do contain errors. They are...

Forgive me for asking a basic question but did you ever enable Database Mail? sp_configure 'show advanced options',1

go

reconfigure

go

sp_configure 'Database Mail XPs',1

go

reconfigure

go

So a tail of the log backup does not require the data file to exist. Thanks!

Dan