Hi..we are experiencing same sort of issue in our production environment. SQL job is getting failed for few intervals and once we re-run the job its getting completed successfully. Network...

Hi..we are experiencing same sort of issue in our production environment. SQL job is getting failed for few intervals and once we re-run the job its getting completed successfully. Network...

Team dba,

I just need a clarification if I have my primary server a standard edition of sql server 2008 r2 and my secondary server is sql server 2008 r2 enterprise...

I have an alternative to it.Please let me know if that will work.I will add another data file and move that specific table into that data file and then shrink...

Agreed..but I want to shrink my data file since my drive on secondary has less space which is less nw for current size of the database..can i go ahead and...

Dear All,

Even in my environment we need to purge the data from one of my table.But our concern is after purging my data will that reduce my data file ???