That is not clustered...

When I restore a full back up then I also got a log file at restore...

So we are taking full backup Is it not included log backup itself...?

Dear,

I am taking full backup...

I only want to shrink my log files without deleting.....

Dear Silver,

I have no idea...I am also searching and waiting.....

Dear Gila,

Thanx for special attention..

one transaction log file

size 11.6 GB (before) now 1MB

recovery mode full

daily backup at 9:00 pm

Dear Gila...

Thanx to write...

I know all but currently I was testing on a dummy server....

I have searched it but I have not found any other log file.....

Hi silverfox ...But I have not found any other log file in whole computer...

Thanks to write..

Hi Gilla Actually my servers are full of logs and in near future I have to make space on drive....

Working

Thanks Vishal...

I have changed the listen all property of Tcp/Ip to No.

The Following errors are coming again and again in eventvwr:

1. The description for Event ID ( 17182 ) in Source ( MSSQL$DOPMAILDB1 ) cannot be found. The local computer may...

you have written very confusing please clear it

Generally what DBAs recommend

what port should I select for other node other than 1433