Excellent !! It worked.

Thanks very much for your help.

Regards

Chandu

Thanks once again for your help.

What is 128?

I have already run following statement:

backup log wslogdb50 with truncate_only

Regards

Chandu

Hi

The statement seems to have completed without any error. But, I am getting following message:

Cannot shrink log file 2 (wslogdb50_Log.ldf) because all logical log files are in use.

(1 row(s) affected)

DBCC...

Hi

Thanks for the prompt response.

I get following output for SELECT NAME FROM SYSFILES:

wslogdb50

wslogdb50_Log.LDF

I am getting "Incorrect Syntax error" when  i include .ldf in the DBCC shrinkfile command.

Regards

Chandu

Thanks Vikram.

Thanks for the response.

How to create linked server through EM?

Regards

Chandu

Hi Chandra

Thanks for information. I am sorry that I could not proceed with the suggestion u made earlier.

I got confused with several updates and was not sure of using the...

Hi Prakash

What a simple solution!

back log helpdesk with truncate_only worked. I can see now my transaction logs shrinked to 51 MB.

Next problem is how to reduce the size of...

Hi

Thanks for checking.

It is a still an issue.

I am confused with several suggestions made. What to implement?

I would appreciate if u have any suggestions.

What are the options available...

The following statement did not succeed:

Dbcc shrinkfile (helpdesk_log, 5000)

Output:

DBID 7

FileID 2

Currentsize 2068464

Minimum size 96000

Usedpages 2068464

Esttimatedpages 96000

The Database size is 600 MB while Transaction...

Hi

It is mentioned in the SQL Server Book Online that "You should truncate the log file prior to shrinking the file to reduce the size of the logical log...

Hi Steve

Thanks for the prompt response.

I would be thankful if you could clarify the following:

1) Will log file size reduce after shrinking the log file?

2) What are the implications during...

We backed up the database and then truncated the transaction log because

it was 164MB whereas the database is only 35MB. All the errors seem to be occurring

on the Log Reader...

Thanks very much Andy for the prompt response...

Which version of MDAC do I have to download and install?

Do u think any problem in the Server itself?

Thanks once again,

Regards

Chandu

Hi

The complete error I got during the installation of SQL Server:

Installation of Microsoft Data Access Component Package failed

Request for any assistance.

Thanks in advance

Chandu