Oh, awesome !

Thanks

I see. For the log, the best is to keep only 1 file, even if it's a 30+GB file?

For the data file, first step will be to restore the...

Thanks,

As of now, we have a log file of 30GB. I was thinking of creating 3 of 10GB, for better performance. This is not a good idea?

When I will...

Doooh ! Right !

How I can get the current start date & time. xp_sqlagent_enum_jobs return the next_run_date and next_run_time. If we start the job manually, I need to have the...

I see.

Base on this, fields next_run_date & next_run_time are the information of the process currently running, right?

But from what I can see, sysjobhistory doesnt not contain the jobs currently running. I want to monitor the ones currently running.

Yes, I want to be notified when some specific jobs run longer than expected.

Any idea of hoe I can do that or modified the procedure I posted?

We are using TortoiseSVN here for source control. But I can't find any plugin to connect this source control to SQL2005/SQL2008/SQL2012.

If someone has succeed, please let me know how...

Hi,

Thanks for your reply.

Basically what I want it a copy of the DDL in case someone mess with some objects. We don't have a source control and I just...

Unfortunately, under that directory I dont see any log with the update of my cube.

Thanks everyone.

So I can use Express 2012 free on a dev machine, right? Or buy the developer edition for about 50$.

Rem

I meant OS and SQL binaries RAID 1

This is for a data warehouse. My concern is the lifespan of the SSDs disks. As of now we don't have any SSDs in house, but it is...

Thanks for your help.

Thanks,

You mean stick with 2008R2?