I waited for 4 hr. It depends how big database you have. I think let it run and wait for some time.

Thanks for all your help.

The recovery process ran for some time and then recovered the database. I did not do anything but to wait.

Yes, I am using snapshot in the replication.

Here is my goal.

1. I wanted to replicate data in batches. Every week around 2 million records should be replicated from publisher...

Thanks for the reply.

The command you have mentioned will only tell you that how much free space on all the drives but how can you tell which process is filling...

There is a tool called HyperBac which is very good for copy particular table and rows. It has a great feature and also it's very cheap.

try this link

http://www.dell.com/downloads/global/solutions/Dell_hyperbac_white_paper.pdf

Looks like, I have RTM version of SQL Server. I need to install SP2 and then hopefully error will be fixed.

My suggestion is to have a following drives.

1 . E drive is for Data files. If possible , create a file groups and stores those file groups on different drives.

2....

I just found a trick to check two instances of same exe file in task manager. I would like to share with you guys.

There is a dos commant called tasklist...

Try this.

select

(sum(awe_allocated_kb)/1024)

from

sys.dm_os_memory_clerks

I can start the mail server but when I stop it gives me following error.

Server: Msg 17955, Level 16, State 1, Line 0

xp_stopmail: Failed to stop SQL Mail session.

1) If we allocated 28 GB memory to SQL Server, we should have 4 GB for OS and other applications. I only can see 1.7 GB, see below. I can...

Thanks guys,

Recovery process is finished and it took few hours. I have noticed one more thing that even if Database is in simple recovery mode , Transaction log files...

Is it recovering uncommitted transaction from the transaction log file. If that is the case then I can open database with out transaction log file and let system will create...

IO is increasing and it's running 5 hours.

Actually, I was in a process of deleting records and then cancel the query.

I think even if I want to restart the...

Thanks guys.

Here what I have done.

1. Create temp table to store data which I have to keep

My tempdb and Log is on separate drive and have lots of space.

so space...