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...

for your suggestion...

'Check the account that SQL runs under, check what permissions that account has on the share.'

i hv no idea how to check.can you please provide more details...