I did check the timeout value for this task and it is 0.

However the jobs are going through successfully now.

May be for that time period something might happened to the...

I have not explicitely setup anything. Can you please tell me where to check it?

Thanks for prompt response.

We generally should try to use the best possible data type. If tinyint can serve the purpose, smallint/ int should not be used. It affets the total row size. The...

Bingo!

You are correct!

Its the same bug which was not allowing me to configure the database mail on server instance.

The database mail wizard of another instance from another server was open...

Backup set expire window specifies when the backup set can be overwritten by another backup set.

It does not delete the physical backup file.

To remove the physical backup file, you have...

Can I allow VM to float around 2 physical servers if all 4 physical processors in underlying 2 physial servers are licensed. (since i have 4 processor licenses)?

Is there any...

This was a discussion going on with my previous manager. So I am digging into the policy.

Let's say I have 4 SQL Server R2 Std per processor licenses with active...

It does not report any success or failure. We have to stop it manually.

Thanks a lot.

It is really a good article to know backups in depth.

The SSIS package runs using BIDS or SSIS but when used with SQL Agent, it continues to run without showing any success or failure.

We have to manually stop the job,...

Thanks all for your help.

We could restore the instance without much data loss and now application is up and working fine.

I am going to use SQL Server management Studio to restore the database for point in time recovery.

So should i first restore the full database backup and then transaction log...

One more thing.

How do I retore the databases in order to recover the data?

As we have lost LUN, we don't have database running up to take tail log backup.

We just...

Thanks for your reply.

I was having the same solution to install a new fresh instance and then configure the things.

Though we don't have a backup (even external backups), we have...

Thanks. I got the answer - its only because of conflict order by clause is having. If we give alias, yes it works.