Hi Gail, Brandie,

I really appreciate the helps granted by both of you to me.

I managed to shrink down my log file yesterday as per advice by Gail.Hence, this is the...

Hi Gail,

I will carry out to shrink the log file this morning, here are the steps to carry out:

1. Change the Database recovery model to simple.

2. Execuate checkpoint command;

3. Shrink...

Hi Gail,

Thanks. Yes, I will need to do more reading on these subjects..

I will do the shrinking of log file tomorrow morning as have a database backup scheduled tonight.

Thanks.

Regards,

GilaMonster (10/10/2010)

---

In...

Hi Gail / Brandie,

SO, just to confirm that these are the right steps to carry out:

1. Changing my database recovery model to simple, and immediately run a checkpont. (Is this...

Hi Brandie,

Thanks for your reply.

I understand better the simple and full recovery mode at the time being. I think I will consider these two model for my database. Thanks Brandie....

Hi Gila,

Thanks for your prompt response... Really appreciated...

Sorry that some questions from me...

-You means only need to run checkpoint for one time?

-what you means by "Checkpoints run...

Hi Gail,

Thanks for your helps ...

I will adpot your advice given. Before I proceed, I have few question to check with you. Sorry for bearing with me...

I have a SQL...

Hi, Brandie/Gail,

First, Really appreciate the helps from you all.

Yes, I would like to be sure before I start to do it.

I have read the article several times, here is...

Hi Gail and Brandie,

Thanks for your helps so far.

AS I just take other this DB job, I really need you all helps to slove this urgent issue now...

My current database...

Hi,

The backup is on Database and the mode set is FULL. This backup plan is scheduled to run on every monday, wednesday and friday @ 10p.m. Thanks.

Brandie Tarvin (10/7/2010)

---

liewsb (10/7/2010)

---

my...

Hi,

First, like to thank for all the advises given so far.

my scheduled backup is from Right click on DB->Task->Backup, and choose Database. The output file is having extension .bak

Thanks....

Brandie Tarvin...

Thanks. WIll read the article and...

GilaMonster (10/6/2010)

---

Neither initially.

We have a schedule job to do a full backup on the...

Hi Ashish,

Sorry to ask that should I choose the file or Database? I am new to SQL 2005 and just takeover the this new job. And only recover that...

chris.s.powell (9/29/2010)

---

Do you ever receive an error message or a dialogue box or time out? What about the event log, can you see anything in there, is it possible...