Thanks Grant .. Can you suggest any tool to reduce the RTO?

The exact reason is the BC team want to reduce the RTO from 100 minutes we mentioned...

Used Symantec / Backup Exec, then switched to Avamar Backup. But I only use native backup on sql server side; once the backup is done, backup team can back...

I'm not aware of this tool, so no real comment on it one way or the other.

However, the rules for any 3rd party solution for backups are very simple....

Never heard of it but from a quick google it seems its another DELL EMC product.

We did have Data Domain at one place I worked another DELL EMC product...

Hi Experts,

Currently we are using SQL Server and Database Mail to send reports and with new projects and requirements it seems like the Report sending will increase ....

• This reply was modified 4 years, 10 months ago by  VastSQL.

SSRS is fairly solid for this

you can subscribe to reports (and get them emailed to you) and keep historic versions on the server... plus you can export in excel,...

It all depends what's required.

SSRS

PowerBI

Tableau

Qlik

All of these are data visualisation/reporting tools.

But it depends what's needed, just a simple dump of data, send mail is a crude way but hey...

so you are telling us that doing a

insert into archive_table
select *

from main_table where filtering_column = date_to_archive 

takes 5 minutes?

or that it takes that amount of time retrieving...

Thanks Paul for the wonderful script.

I have a requirement where the Primary and Secondary are in totally different domain. Now I am moving files through FTP. Can you help me...

Thanks Lindsay,

Can you help me understand the impact of the same in a cluster?

Thanks Mike.

Checked with Network team and they are not able to find anything.

From my investigation its pointing to database mail and service broker.  The error is thrown when the database...

• This reply was modified 5 years ago by  VastSQL.

The error is not very frequent now but happens at mid night .. Is there any probability that this can be a hacking??

(1) Not necessarily.  DBCC CHECKDB creates an internal snapshot of the database.  Database snapshots are sparse files, so they start off at (near) zero size and only grow when...

Recently been asked to look at why  ASQL instance will nto start.  this CLuster has not been built to best practice and is a 2 node cluster.  it has...

• This reply was modified 5 years, 4 months ago by  VastSQL.
• This reply was modified 5 years, 4 months ago by  VastSQL.

Rebooted old node and tried again after failover? I assume this is shared storage clustering, so the same master.mdf was scanned with dbcc?

If so, I'd fail back and try...