SQLKnowItAll (4/2/2012)

---

What does it mean that you are starting anew project? Are you going to be a director, DBA, project manager? KT is all subjective based on what you need...

Thanks opc...and can u elaborate the things i need to ask questions to previous dba team... give me as points plz

The person doesn't have that list. I need to prepare and then ask.

Thanks to all.

anthony.green (2/23/2012)

---

the only thing that happens is outside of the local scope is the file copy so you should only need file share ports opening, typically 445 would also open...

I want to know for logshipping port number has assigned to that partner. for this is there any query to find ?

Plz any one help...

Is there any query to find that port number assigned to partners...

How can we come to know the file share is opened, and how to check the port number is assigned for that configuration and all.

Please let me know...

When i execute select query, I have seen in activity monitor of processor in that column name wait time is taking more....

so i wish to know that how to troubleshoot...

In activity monitor, wait time column is taking more.

In activity monitor, wait time column is taking more wait time.

It is showing the results as below...

namelog_reuse_wait_descrecovery_model_desc

nod055LOG_BACKUPFULL

please give me the next step..

No, I didn't run any heavy query with sorting in my side. may be the users are trying it.... so that case how can we find. Please let me know...

But when I try to shrink, I will not get any free space in disk.

I executed the query below ...

DBCC SHRINKFILE ('tempdev', 1024)

eventhough I didn't get free space in...

ya, I got the result below...

namelog_reuse_wait_desc

tempdbNOTHING