Viewing 15 posts - 166 through 180 (of 219 total)
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...
June 10, 2009 at 12:44 am
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...
June 9, 2009 at 10:21 pm
-> 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...
June 9, 2009 at 5:32 am
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...
June 9, 2009 at 12:26 am
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...
June 9, 2009 at 12:12 am
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...
June 8, 2009 at 11:57 pm
thats becaue sp_repldone will update the system tables and mark all the transactions as complete ...this will change the VLF status to 0 ..
June 4, 2009 at 6:06 am
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...
June 4, 2009 at 5:44 am
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...
June 4, 2009 at 3:22 am
On the same KB article check method 2 .....
June 4, 2009 at 3:17 am
it wont work .......as its doing intersaction ...
May 31, 2009 at 1:04 am
Give me the table structure ...i.e. the create table script ..
It should not be difficult...
May 30, 2009 at 10:37 pm
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...
May 30, 2009 at 10:33 pm
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...
May 30, 2009 at 1:15 am
Viewing 15 posts - 166 through 180 (of 219 total)