Okay...what if my backup finishes before my index creation. How much of it will be backed up? and if it's in simple recovery...and it's a full backup.

Regards,

Faisal

Thanks! Grant.

[font="Comic Sans MS"]You're welcome.

Yes it does push the changes made at the subscriber back on to the Publisher.[/font]

[font="Comic Sans MS"]I believe 5 cr request is not that huge. We have a setup with transactional replication that transfers millions of records for reporting purposes each day. As per...

[font="Comic Sans MS"]Hi,

I'll be brief in my explanation.

Snapshot replication distributes data exactly as it appears at a specific moment in time and does not monitor for updates to the data....

Thanks Perry,

But that's not what I am looking for. Instead, something in powershell would work wonders. I would only like to have to get those 3 parameters from the system...

Hi Anthony,

I tested this powershell script, and it's working amazingly well. The only problem that I am facing now, is that my boss is looking for something which needs to...

Thanks. Ignacio 🙂

Appreciate your help, but is there any way you can modify my code, so that the daily reports are clean and tidy.

Regards,

Faisal

I want page reads as well as io reads & writes i.e (logical & physical reads/writes). We actually show these results to our sysadmin guys, as they want usage details...

Jessie,

Sorry brother but this code is really not doing anything for me. Whenever I execute this sp it runs successfully but at the result pane I can just see (0...

Thanks. on millions Jessie. I'll rigorously test your code, and let you know how things are working in my environment.

Thanks. a lot.

Regards,

Faisal

Thanks. Jessie,

Really appreciate your quick responses. I'll again run that code of yours, onto other servers, and check the response. What about the e-mail part it should mail me, there...

Hi Jessie,

It seems that your code is not working correctly. After creating the stored proc, when I execute it just completes it's execution within no time...something in the code doesn't...

Hey Jessie,

That's what I don't want to do providing the linked server name each time for the execute statement. I would like to store all my linked server info in...

Hi,

I would really appreciate if you could write a code which will get results from all the servers through linked servers, and could mail the DBA's with a really nice...