I appreciate the help everyone has provided.

As a quick question, what is the proper method for backing up tlogs? Do I use Enterprise manager? Should I use a script?

I am...

Just a quick question:

When I backup transaction logs, should I do it using the backup method within Enterprise Manager? Or should I use a script of some sort?

Secondly, I would...

Thanks guys. I appreciate it.

Here were the two books I was curious about what the difference is:

http://www.amazon.com/Inside-Microsoft-Server-2005-Pro-Developer/dp/0735621977/sr=8-1/qid=1165539295/ref=pd_bbs_sr_1/002-0017924-5084072?ie=UTF8&s=books

http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735623139/ref=pd_bxgy_b_text_b/002-0017924-5084072

Here is a list of books from...

Thanks. I appreciate it.

What is the difference between SQL Programming and SQL T-SQL Query programming? (I think thats it)

Perfect. That helps me out a lot. Thank you very much.

I wanted to manually run some backups this morning and push them to a tape.

I can do this in...

Thanks Greg. I do appreciate it.

Just to follow up and make sure I fully understand a few things:

Setting up the DB to be fully backed up every 6 hours is pretty...

Thanks everyone. I appreciate the input. I can't thank you enough.

Just a quick question: When you truncate a transaction log, does it actually shrink or make the actually .ldf file...

Thanks Greg. I really apprecaite.

Would you recommend that I continue to use the Veritas agent for backing up the database and transaction logs? I came across a couple of interesting...

Thanks. Very interesting.

let me ask this: Since the transaction logs have never been truncated, which course of actions hould I perform?

Should I backup the logs then truncate them?

After that, just...

Hi, thanks for your reply. Here are some answers and more info.

Our data is very important. holds all of our customer data.

Change is daily, but not a high number of...