That is absolutely correct.

This will keep your transaction logs from filling up your log...

That is why Microsoft doesn't support this type of installation.

What is the reason to brake a...

It will be saved nowhere.

As I said run this script...

Shrinking The Log file in case of emergency situation is the only idea.

And it is very common when even having great...

BACKUP LOG yourDB TO DISK = 'D:\SQLBackups\yourDB.trn'

DBCC SHRINKFILE ('yourDB_log', 200) WITH NO_INFOMSGS

You should run it as one single transaction

If you don't have a log shipping or replication running on your...

What is your DB's recovery model?

Raghavender (9/24/2009)

---

Its Enterprise Edition.

And my OS is Windows XP with SP3.

Actually first I have installed the SQL 2000, 2005 and 2008.

Due to some problems I have uninstalled all of them.

Now...

It is a good question.:-)

Without seeing the database and a table it is difficult to be very specific, but the general guidelines is here.

1. Use table partitioning (vertical or horizontal)...

Such an association between a thread and a processor is called processor affinity.

Although efficient from an operating system point of view, this activity can reduce Microsoft SQL Server performance...

What Edition of SQL Server are you trying to install?

What Windows OS do you have?

Thank you for update, it is certainly a good news.

vsmurali111 (9/23/2009)

---

good catch.

I am trying to attach the model db from E drive before and it failed.

I did found that the modellog.ldf system handle is pointing to D drive.

How do...

You are on SS2000.:(

The model and msdb databases can only...

1. Script your replication

2. Disable replication

3. Detach database

4.Copy database files

5. Attach your database

6. Run your replication scripts from SSMS - your replication will be recreated.

7. Go to the Replication agents...

It could be not a SQL Server process, but OS process as a result of previous attempts to fix...