Tom,

Thanks for your note.

Are there things I wished I would have done differently? Sure, but big picture wise my mistakes or things I wished I would have done differently,...

I could not agree more.

Thanks for your note.

I am often asked about the Marine Corps training. There are many aspects to the training, and I remember being told about how they...

The first idea that comes to mind is that in your second table you are going to limit yourself to the number of properties that can be added. In...

this way you can send alerts and results from queries. An example of the way I have used this in the past. I had a SQL Server that...

I don't think you can rebuild the log when using the UI, however this is off the top of my head, and well age is not doing my memory...

Do an sp_who 2 and log it to a table from a SQL Agent Job? I may be reading a lot into your question.

Hi Benki,

I think there are a few things that you may be missing on the answers that everyone has provided to you. I hope this answer helps you.

There is...

Can you use Create Database for attach with rebuild log?

I hate to jump back in on this,

I have built reporting enviorments like this in the past. Where, we would copy the Full over each week, and the Diff...

You had mentioned that Log Shipping is not an option because the data is not readable? There is a option where you can make the database readable.

When...

Make sure you check this out as well.

http://www.sqlservercentral.com/stairway/72400/

A good place to start is SQLPASS.org

But search the web for your town and SQL Server User Group. If there isn't one near by, look for like...

In addition to Louis Davidsons book, I would look at getting invoulved with a local User Group, and network as much as you can. One of the best things...

I think you may want to consider looking at some monioting tools. You can set up alerts and use some of the features in SQL Server to do mail...