Why do I see these two files at the first place?

Mssqlsystemresource1.ldf

Mysqlsystemresource1.mdf

There are other instance on this server where SP4 installation was successful and I only see below two files...

This is Windows server 2003.

I also right click on installation file and chose "RUN AS ADMINISTRATOR" and it still fails.

I tried giving "EVERYONE" and my system admin account full permission for all these 4 files manually and still installation fails with the same error.

I also tried giving "EVERYONE" and...

Thanks for you reply.

I didn't try installation by right clicking and running as an admin and I can't do it now until the next maintenance window comes. I am just...

So conclusion is to create a clustered index only on contact_id column and get rid of nonclustered index.right?

Thanks folks for your replies. It was third party sql red gate back up. It was failing because there was no disk space. I think because of a bug in...

Hi Stax68 and Peter,

Thanks a lot for both of your reply.

Stax I worked on your suggestions.

(i)I checked the schema but the whole database is a mess. SupplierOrders doesn't have...

I know I can can script out the jobs, by rightclicking the job and chose All Task -> generate script. How to recreate a new job from that saved script?

To...

Hi Rudy,

I'm new to sql server administration. I'm a developer.

(1) How do I script out the job? Is there a way so that I can just copy the job...

Hi,

I tried changing the owner to someone else then again back to SA. Now something is weird happening. Job is still failing but in the view job status history i'm...