SAN goes down???...:w00t:. I am glad we have a one year tape backup retention policy..:cool:

I hope this does not break the log chain.This needs to be done on Prod Db, that's the reason I am leery about this. In case I switch the recovery...

Did u have updates in the past 3 days??

How much of data do u expect you would need to recover??

What about the backups, when was it run the last time,...

Interesting to know all kinds of setup with respect to assigning tasks for DBA's in batches. Well I am the only DBA for all environments but one positive thing is...

Is it a disk backup or a tape that you are restoring from?

How to view page spilts in a table? Also what is the desired value for % EXTENT FRAGMENTATION?

Thanks!!!

How do I set a variable fill factor, because the way I see it there are a bunch of tables that are static and then there more than a couple...

All the mdf and ldf files are stored on separate RAID 10 drives with 50 spindles each. The backups again are on a separate RAID 5 array. I am not...

I used this script on some smaller databases to reindex in the past

select getdate() as TotalStart

exec sp_MSForEachTable '

print ''?''

select getdate() as starttime

DBCC DBREINDEX(''?'')

select getdate() as endtime

print ''-----------------------------------------------------------------''

'

Hi bkDBA: The issue is slowness of the system. We are got rid of 5-6 years of data and to ascertain if we actually have a performance boost we are...

Batching the index job in two sets : Does that mean I issue multiple DBCC commands?

Gail :The test server is 4X16 on 2000 SP4, prod on 8X16 2000 SP4. We...

It took 4-5 hours to rebuild one Index(clustered)

MANU the article was very helpful. I don't think there is any hotfix to take care of it. But then can I set up a job to notify me upon...

Backup restore is the best bet.But make sure you have everything sorted out before you start to mitigate the downtime....

We use spotlight, never had any issues with it. I suggest you request a demo for spotlight at http://www.quest.com.The licensing and all issues can be asked for with the support...