Colin Betteley (1/13/2010)

---

I have SQL 2005 Enterprise installed as a default and a named instance. I have Administrator access to the server. I have sysadmin access to both Instances of...

Dave H. (1/11/2010)

---

Hi,

I'm an experienced developer, but new to SQL Database administration.

Recently I designed a web site using .NET with a back-end content management system using a local database and...

First y u want shrink it,5Gb is not big one.

Read the MS KB-307487

sgambale (1/11/2010)

---

I cannot shrink tempdev data file in tempdb even though almost all the space is unallocated:

database_name ...

Vivek

How u r rebuild the indexes through M-P.

IMO:

Don't shrink any of files because it ll grow again and again & cause the physical fragmentation.

Vivek29 (1/11/2010)

---

Rebuilding an index is a logged task. So can anyone clarify that if a shrinkfile is done after rebuilding an index, does this task still have an effect or...

Ali_SQLDBA (1/9/2010)

---

42.04962GB --LDF

46Gb --Total

4.41632GB-- MDF

Actually, we dont take any log backups. All we do is daily full backups. Also, the recovery model is Full. I know everything is smelling weird....

Ali_SQLDBA (1/9/2010)

---

Also, in sys.databases, the log_resuse_wait is showing 2 and log_resuse_wait_desc is showing log_backup. Can you advice what is the course of action for this. I read in one article...

Ali_SQLDBA (1/9/2010)

---

Thank you for your immediate response.

Yeah, at that point of time there was no other go for us. So I shrinked the t-log. i was able to recover 3gb....

Ali_SQLDBA (1/9/2010)

---

I am also facing the same problem. Today, our disk which holds the LDF's ran out of space, as a temporary action, I ran shrink on ldfs through management...

What george said is

GRANT VIEW DEFINITION ON [DBO].[proc_name]...

SQL Server has encountered 32 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [G:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf] in database [tempdb] (2). The OS file handle...

sqlnsg (1/8/2010)

---

Thanks a lot for all your inputs and feedback. Ok basically the issue here is SQl dose'nt respond to client request in particulat , its diffcult to capture...

Look the BOL.

Krasavita (1/7/2010)

---

My SQL is the Standard Edition. and SQL is running under the Local Service Account that account by default had the Lock Pages option enabled (even though the...