FOR SQL Server 2000

-----------------------

If your backup is corrupt irrespective of LDF or MDF , you cannot restore .

If you have the LDF and MDF files but MDF corrupted , you...

I have been through this blog post by Slava many times (i am ex-microsoft)..this was published in 2005 when SQL Server 2005 was RTMed.

from this post i disagree with the...

Thats what Paul meant 🙂

-> copy the actual mdf files to a different location or rename it to _old.

-> note down the correct database name

-> create a new database with the same name...

The number of pages being accessed are physical read and logical read combined .You should find the queries being fired (using profiler).

Once you have the queries run them individually and...

Agreed with Steve ...please ensure that you are restoring the right Differential backup ....

One more point came to my mind but i am confident that i am wrong 🙂

I was...

Let me clear some doubts :

---------------------------

AWE is only meant for 32 bit architecture because of its virtual memory limitaion of 4 GB .For 64 bit the virtual memory is more...

thats becaue sp_repldone will update the system tables and mark all the transactions as complete ...this will change the VLF status to 0 ..

Joy ,

Let me clear your concept here .

When you use the sort in tempdb option the intermediate sorting is done in the tempdb .This improves sorting speed but does...

What do you mean by dump ??

support.microsoft.com/kb/303747 : Install SQL Server 2000

technet.microsoft.com/en-us/library/ms143516.aspx : Install SQL Server 2005

msdn.microsoft.com/en-us/library/ms189462.aspx : How to create schema ..

Looks like you are too much dependent...

On the same KB article check method 2 .....

it wont work .......as its doing intersaction ...

Give me the table structure ...i.e. the create table script ..

It should not be difficult...

Well , the duration of the IO depends upon different hardwarw : amount of RAM , spindles and potential of H-Disks , Device drivers , OS and the patch level...

Anyone who is experienced in 823 will be able to tell you that you need to get your hardware checked ....823 / torn page issue comes when the page or...