..OK..

Need to check if it's using Virtual Shadowcopy as part of it's snapshot process.

Thanks Grant.

Thanks Grant & Perry

If you're in the extremely large database sphere, you may find that backups running for 26 hours just doesn't work. Especially when restores can take 30 hours...

Snapshot of the disks is being done by respective...

Hi Gila,

Thanks !.

We have purchased 2014 enterprise edition licence, core based. However the application doesn't support 2014.

Hence 2012 needs to be installed. Can I download it from the below link...

Thanks.

However, don't know why, it was not downloading from that link. Download speed was too low like 6kb. Not sure why so.

Issue was with only this link.

Now I almost...

Perry Whittle (3/27/2015)

Joy Smith San (3/26/2015)

Mirroring has been configured for one of our database.

OS team wants to apply some patch for windows. Whats the best approach to do it...

I created a job with only the command

"Select getdate())" which has syntax error in it.

The job failed. But,

1. It created the file when it was not there.

2. It updated the...

Thanks Jeff.

I thought its 180 days. Well, it will be a separate temporary server.

So I just need to backup and restore all user DBs to the new prod server...

Thanks. No need of msdb. Only user dbs are ok for them.

.... and I think for Enterprise edition it's only core based license... CAL is not available for EE...

Yes, it can.

OK... Thanks.

Is there any workaround for this ?

No response at all... 🙁 🙁

Thanks all.

I agree that it's bad idea to let them kill spids.

But we are not going to give it as it is. We are planning to develop a customized sproc...

Thank you all for your valuable suggestions. Yes, I am clear on that part. I am planning to give them rights to find and kill their queries, if they cannot...