dakshinamurthy (12/31/2008)

---

Hi,

How to make log-shipped database to be available for queries.

I have MyDB in one Server which is used for Log-shipping and in the other Server MyDB is getting...

kiransuram19 (12/31/2008)

---

Hi,

we have 100 's of jobs in a server and one of the job is not scheduled but it is called from other job(same server job or from different...

i can create a single directory or single file but not all

Warren Peace (12/30/2008)

---

I have some temp tables in my system tempdb that I need to kill.

They are called #SOMEHEXNumber etc...

I can not do just a "drop table #SOMEHEXNumber ". I...

GilaMonster (12/31/2008)

---

This is all-around some of the worst advice I've seen recently regarding transaction logs in quite a while.

Paresh Prajapati (12/30/2008)

---

--Check any transaction is open or not when taking a...

it is there page...

so, what to do?

seenu_61281 (10/23/2008)

---

I would like to be a DBA in sql server.i am little bit stronger in sql queries,sp,views...

i know basic import/export thru DTS wizard.

What are the other things i should...

FNS (12/30/2008)

---

If a server keeps running out of space for the tempdb one option seems to be, move tempdb to a drive with more space. 😀

However, what's wrong with just...

iqtedar (12/30/2008)

---

thanks everyone for all your answers..

Rajni..i see the jobs...i do not think msdb is migrated bcoz in the porp it still shows the old date.

Jonathan..the packages were migrated long...

branovuk (12/30/2008)

---

Hi,

I have one problem with production database. Transaction log is growing fast. I have daily backup. And it worked if I backup log file only, two times, than shrink...

madhu.arda (12/30/2008)

---

Hi,

We have SQL Server 2005 EE x64 a\a\p cluster setup on windows 2003 EE x64.

Node1 has i insatnce

Node2 passive

Node3 Has 4 insatnces.

We 16 GB RAM on all nodes....

DBADave (12/29/2008)

---

My mind is mush after reading numerous papers on monitoring memory. Most of what I found was in regards to what DMVs and perfmon/sysmon counters to check, but...

raj acharya (12/30/2008)

---

hi sory please ignore previous one... i want to say that it's replacing your data with old data that because of first step of snapshot taken by process...

krayknot (12/29/2008)

---

Paresh Prajapati (12/29/2008)

---

I have transfer database backup file on network storage device by FTP.

When i upload backup file on FTP it reduce size of backup file.

why it happen?

Bec when...