JIM HOLCOMB,

a text from SQL Books Online please go through...It only reduces empty free space of Transact log only. and once you set the "truncate on check...

Jim,

Do the following and your problem will be solved

sp_dboption 'Database_Name','AutoShrink','ON'

go

sp_dboption 'Database_Name','trunc. log on chkpt.','ON'

go

DBCC ShrinkDatabase('Database_Name',10)

go

This way your transaction log will remain smaller in size.

LeoAugust

hi Ruberli,

Their is no need to run the backup every now and then, you set the database option such that you dont have to do this again and again

do the...

Thanks Donaldw and Remi

Thanks guys for all your valuable support, I have tried install MS SQL Server Pack 3 and all the Default as well as

Remi / Donaldw

Here is the windows log i have copied only the required portion, i thinking it is listening only on Shared memory and also it has given one warning...

Remi / Donaldw

My errorlog reads something like this

2005-08-26 10:11:43.94  server SQL Server is ready for client connections

2005-08-26 10:11:43.94  server SQL server listening on Shared Memory.

2005-08-26 10:11:13.21  spid3 Recovery complete.

2005-08-26 10:11:12.98  spid5 Starting up database...

Donaldw / Remi,

I am using Sql mixed mode to access the server.

Leoaugust

Thanks Donaldw,

I have not checked the ErrorLog, i will certainly. But i have checked few other things like, I am not able to access the Sql Server by IP Address...

Thanks for reply,

We have disabled our firewall which on by default in WIN XP SP2.

Still the problem persist.

Point 2 is not understood properly.

In our server network utility...

Dear freind,

use the following options and run them in Sql Query Analyzer

in place 'pubs' use ur database name, it will set the database option of autoshrink on and also set...