[font="Arial"]

Yes ... this sounds good. I will move to this direction.

Thanks a lot.

[/font]

[font="Arial"]

I don't use Windows authentication but SQL "sa" authentication, so i this case there should be no problem i feel. So, i should be able to restore my original DB...

[font="Arial"]

Yes Gail, i've thought something similar .. In any cases i've preferred to execute a new query defining the old path for the ldf file. I will attempt again next...

[font="Arial"]

HEllo ... I did what you said and the Shrink operation was good.

The moving to another location has an error ...

Seems thst it don't recognize the name as if it...

[font="Arial"]May have sense to set the DB in Single User mode, during both operations?

This may block possible undesiderable access attempts to the DB ... I feel

Alessandro

[/font]

[font="Arial"]

Ok Gail ...

Now all sound good .. I've understood some things that were not so clear for me.

Tomorrow i will attempt to apply what you've suggested me for the DB...

[font="Arial"]

For example, please, see this link in the section B) Shrinking a Log file to a specified Target Size:

https://msdn.microsoft.com/en-us/library/ms189493.aspx

Probably i feel that this can be because is better to "break"...

[font="Arial"]

In addition ... Why you are saying that it's not necessary to switch to "Simple"?

This is written more or less in all documents that i've found on Internet, both from...

[font="Arial"]

I have attempted to make a simulation using the SQL Management Studio, so that DB name and parameters should be the right ones).

What it write on the Script is...