Three basic steps are

1. configure distribution

2. configure publication

3. configure substription(s)

Since you're keeping your distribution and subscriber on the same server, i dont think there will be much difference between pull...

Thanks Gail and Abhay. It did clarify some of the doubts. 🙂

You should have 2000 SP3 or higher to perform an upgrade to sql 2005.

Also the link to the document mentioned in the previous post is

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&displaylang=en

Sourav Mukherjee (7/5/2009)

---

Does anyone have any doc which clearly talks about SQL Server Architecture? If it can tell about -

Data,log files, optimiser, check point, memory and other related stuff to...

Thanks Gail for the info. I'm sorry but how IO can crash a page is still not very much clear. Few examples or something you've experienced in past or links...

Performance issues are perennial issues and have to be dealt with carefully to have them sorted permanently, so what...

Ahh, I forgot that the corrupted database was in 2000:hehe: and page level restores is possible only in 2005 and later versions? My questions in the previous posts still remain...

I was just going through some articles and came to know that i could have recovered only the affected pages if i had a clean backup instead of restoring the...

Model database hardly changes. It's used as...

If you reinstalled sql server coz of corruption, i think it'd persist as corruption happens to your database files. If you do not have a clean backup, i think u're...

only4mithunc (7/5/2009)

---

Hi , thanks for the reply,

If you dont mind could you please make it more clear..?, what i did is i got the .mdf and .ldf files(actualy my friend...

The error message says the while backing up the database, more than one file names were specified which means the backup was stripped, meaning backup of the database were taken...

Sourav Mukherjee (7/5/2009)

---

Could you please let me know how the SQL Query Analyser determines whether it will go for Index Seek or Index Scan?

Can you please provide me some clear...

Sourav Mukherjee (7/5/2009)

---

1. Checked for blocking running sp_who2

2. Executed Profiler to check what are people running the queries.

3. Checked the tempdb whether the mdf and ldfs are full. Everything was...

You can group the users into several AD groups, Like one group having insert/delete persmission, Other group having only select permissions and add these group to your database with appropriate...