It would be best if you read this article [/url]by Gail Shaw.

If you truncate log file, you are going to break the log chain.

Even though it threw an error, it seems like the DB was successfully restored. Can you check and see if it is restored properly?

You will have to monitor the DB. You could try running a server side trace to find out which is the costliest and what is doing.

Did you start the snapshot agent after running the query?

Thank You everyone for the input on TVP. It looks like something worth investing my time to do some performance testing.

Thx Stephan, Gus and Jason for the input.

Thread needs only 865 posts to hit 30K and I need 80 posts to hit 3K. Who will reach first, the thread...

I actually write an article fro SQLpass.org site. You need to be a member of sqlpass to read it. If you are, take a look at it. You might find...

No, Max memory is not reserved. Min is reserved. If the pool needs more than the minimum that is already there, then it will take more memory that is available...

Thanks Gus. Appreciate the explanation. 🙂

let us say that there are two pools. Pool a and pool b. Pool a is sitting idle, therefore the CPU is available to Pool B even if it has...

When you have regular transaction log back up the chances of file growing out of proportion is very low. I guess that is why he asked.

Please keep in mind that when you are copying the file over to your network share, the user is you who is probably a Admin on that box. When the...

Can you check what is the increment set for the file growth of Log file? It is most probably set as 10% increment.

The resource governor handles the MIN and MAX setting for CPU and memory differently. In the case of CPU, the MIN and MAX kicks in only when there is contention....

Yep. Advantage for me is that I can review what they are implementing before it hits QA.