It was very quick:-)))

Thanks a lot!!!

But i can't use this Wizard, because it can't use View, only whole DB.

Hello All!

My bad - didn't understand what i need to do.

I have some correlation:

1. In "User_Profiles" DB i have some View.

2. I need to copy all Data from View in...

[Jim].[dba].[Murphy]

Thanks again.

I will most probably open Posts here on regular basis, so be ready:-)(kidding).

[Jim].[dba].[Murphy]

First of all - Thanks a lot for you patience!

Second of all it was for me quite strange to hear, that "Auto grow" it's not so good thing. But...

[Jim].[dba].[Murphy]

Thanks a lot! Really thanks.

I've understood now what exactlly Transaction Log does and why do not perform Shrink.

The second thing what did you mean by: "it is best to leave...

GilaMonster

Thanks a lot!

If i shouldn't do Shrink, so how Log file will be reduced?

DNA_DBA

Thanks for your replay, but i really didn't understand nothing.

I actually have two questions, as you can see and would like to get answers for them.

Thanks.

GilaMonster

Thanks for your answer. If it's only what i need to do, so i will.