Yes, Thats right too, I cannot distribute...thanks for reminding me Gail:D. Now I'll go and get my coffee before I sit and post:w00t:....

GilaMonster (12/21/2008)

---

Krishna_DBA (12/21/2008)

---

Yes, using Testking, Pass4sure are brain dumps and it is not advisable to go through them unless you are confident that you have practiced a lot and grasped...

I need to pass only one exam to get my MCITP.

Its a lot of struggle to get through these exams. First thing be prepared to study atleast 3 to 4...

Hope you will have Fantastic holidays !!!!:)

As a general rule of thumb 100% FILL FACTOR benefits the read activity but slow downs the write activity. As a general rule of thumb, 100% Fill factor for no...

Is the question....When does log truncate happen in Simple Recovery model?......It think you probably need to modify the question ............

3. when does the commited data in the log files move...

Thanks for the extra info Steve.....

Check out whether its the date file which has increased or a log file....

If its a log file, this is due to the rebuild index task. Change the Recovery model...

How about resource system database? does it get automatically...

Why dont use DTA tool and apply the recommendations from there? I am just wondering.....

Its our pleasure !!!

Hi,

Yes this is possible. you should look at Merge Replication which will allow you to update at publisher side and also subscriber side and then resolves the changes made.

check...

this is a wider topic to discuss here. Transaction log backups are those which you can backup from time to time so that you can recover the database to the...

Transaction log and Transaction log shipping are two different concepts. Transaction log shipping is used in high availability and Transaction log is the part of a plan used for disaster...

Why are you trying to truncate the file anyway? Just restarting the server will clear the space used by tempbDB logfile.....