Thanks for the reply...

If ReplData folder contain actual data that means I need to have enough space on disk...I guess all tables to be replicated will make up appx 30...

well looks like sql server service was already started. it recovered master database, finished checkdb and also recovered other user databases during this process...

yes, I started the service manually a day later and was able to do it without any problem... I don't think anyone else has access to the server to do...

Default database for NT AUTHORITY\SYSTEM login is master database.

BatchServer is the server instance name...

If you are restoring through a script then you can also use the option... WITH STATS = 5 or any other number....

Yes I did mention that the database is in Simple recovery mode when I started this thread...

Forgot to mention,

If I shrink in small chunks (releasing 2GB at a time) then it works. But I don't want to keep doing this 50 times..

How do I check that oracle client tools are installed on server or not? I am not using sqlplus. After creating a linked server, I'll just use openquery to fetch...

Thanks for your help Lowell...

I did what you said above and when try to access data I get following error,

Failed to retrieve dta for this request. An exception occurred...

Thanks... I got it...

When installation runs checked files in use it shows wmiprvse.exe and fdhost.exe is currently on. can I stop that and start after install?

Thank You WayneS.......

This is a QA sever. Can other developers use the server to query database while the SP2 installation is in progress?

Do I need to restard SQL Server or reboot the...

Thanks Jeff... I will directly apply SP2 then...

any other suggestions?