OK. This database was around 800mb in size. I picked up another db of 50mb size and the plan succeeded. Need to work on the big db now.

Both servers are on the same domain.No clustering. Both sql services are using same domain admin account now. Previously local admin account. Now backup itself fails.

Error 3202: Write on\\servername\dirname\dbname_logshipping_init.bak...

Help Please !!!

Oops. Wrong. 900meg file to 150meg zip file.

Thanks Allen for your help.

Can I expect a zip size of 800mb for 5gb ?

I am zipping my 900meg db to 15meg zip file now. To transfer 800meg file,how...

Andy & Others,

I need to monitor it in the midnight. Is there a way to set the profiler to start and stop at a...

Is it possible, the initial fillfactor was 90 and now you are doing it for 80 ?

Is the total size of db same between prod and devl?

Thanks much both of you. After doing more research, unicode is causing this problem. I will take it from here.

select * from Cust where cust_no = '1234567'

uses the clustered index.

select * from Cust where cust_no = N'1234567' is not using it. It uses a nonclustered index on title. But,...

Ooops. My showplan is not using the clustered index. It uses a non-clustered index on title. there are 8 distinct title values in the 200,000 table including...

Thanks for your replys. I am going to work on it. It has all the issues you have specified.

1. I have 2gb ram, which is not sufficient...

Thanks for your info.

By the way, to fix the public execute permission, I copied an existing script in this site, and modified it:

declare @procname varchar(100), @command varchar(100)

declare Crs insensitive cursor...

If a user is executing a stored procedure which internally creates a temporary table, then i need to give ddl_admin privilege in the current db and tempdb. Is itn't it?

...

All I want to do is to give users read,write and execute permission on the database. So I thought of creating a new db role and assign db_reader,db_writer and ddl_admin...

Around 30 seconds. But overall, the cpu utilization is high on processor 2 & together. After VM increase, the spike came down from high 90s to 70s.

...