Yes, its an expensive operation. Change the recovery model to Bulk logged when you are rebuilding your indexes which will be logged minimally.

fminns (4/7/2009)

---

Well, I thought it was something like that too, BUT if I try to do the same exercise in Simple mode, I get the following error.

RESTORE PAGE is not...

Right click on your database -> Tasks -> Generate scripts and follow up the wizard

By running regular DBCC commands as part of your maintenance plan.

You could also check suspect_pages table in the...

No Problem.

Was your databases in Full Recovery model?,...

Absolutely not. Why you want to try this anyway?

How about this one:

SELECT DB_NAME(database_id), LastRead = MAX(CASE

WHEN last_user_seek > last_user_scan AND last_user_seek > last_user_lookup

THEN last_user_seek

WHEN last_user_scan > last_user_seek AND last_user_scan > last_user_lookup

THEN last_user_scan

ELSE last_user_lookup

END

), LastWrite = MAX(last_user_update) FROM

(

SELECT

database_id,

last_user_seek =...

True whatever Grant advised.

But my two cents:

Its a deadlock between SPID 287 wich has Update lock and SPID 399 which has IX lock and SPID 287 has been chosen as...

Oops you are in the wrong forum then. it works only for 2005.

I am not so sure how you can implement in 2000, lets wait for other members.

Is it SQL 2000 or 2005 you are running?

Any database.

wayne.mcdaniel (4/6/2009)

---

Now the database will not attach in SQL 2005 Express - they get a message saying something like

"The log scan number (xxxx) passed to log scan in database...

True, I tried to set it up too but never had success :~(.

I think gmail offers you some package for small organizations with some little amount to pay. that might...

Basically, in any recovery model Tlog can be reused. Tlog is divided into number of VLF's when one VLF becomes full it uses another VLF. For the sql server to...

oh thanks for correcting it Gail !

also this might be useful there's a live webcast today on fragmentation, check this out:

https://www2.gotomeeting.com/register/271869934

radek (4/6/2009)

---

But let me ask you what made you to defrag your indexes were you experiencing any performance problems or is it a part of your maintenance plan? Since its...