Yeah, i think we're going to need 2 licenses b/c we want to do the automated restore and dbcc check on a mirror server.

Thanks for the...

Let's say i have this backup scenario.  I discover that my most recent backup without the table corruption is DiffA2.

With SQL Backup Pro,...

• This reply was modified 5 years, 3 months ago by  Jackie Lowery.

I'll throw SQL Backup Pro in the mix. Not sure of the cost for you, but you'd have to ask. https://www.red-gate.com/products/dba/sql-backup/

However, I think Ola's scripts with some simple...

• This reply was modified 5 years, 3 months ago by  Jackie Lowery.

Do they support emailing backup results or at the very least just errors?

Also, as a side-note, our current solution is Veeam Backup and Restore.  The issue with Veeam is we can't restore a backup from several days back and all transaction logs...

Is there a reason native SQL Server backups won't work?

Native compression from 2012 and higher has comparable performance to other tools now - and is the reason I no...

• This reply was modified 5 years, 3 months ago by  Jackie Lowery.

I'll definitely look into extended events. Thanks.

Yes, just trying to catch a data change, who changed it, and the SQL text.

So, the user opens a vb form that has a dropdown that they choose the company from. The vb form passes the company(db) to the report.  The stored procedure is...

• This reply was modified 5 years, 5 months ago by  Jackie Lowery.

As you can see, there's 3 different tables i have to query to get the company name, db name, and user name.  The query I've written so far uses sp_msforeach...

The result set will be the Company name and Company database.  I have a vb form that the users run crystal reports from.  It has a company dropdown and a...

• This reply was modified 5 years, 5 months ago by  Jackie Lowery.
• This reply was modified 5 years, 5 months ago by  Jackie Lowery.

We use an app that creates a new db for a every new company, so I don't know how may databases exist.  Also, there are databases on the same server...

• This reply was modified 5 years, 5 months ago by  Jackie Lowery.

But the index is organised as a B-tree, so it needs to search the nodes to get to the min and max values. So depending on the depth of...

Here is the exec plan.  I just figured that since a page is 8K, a single integer would easily fit on one page and since the plan is a seek...

• This reply was modified 5 years, 5 months ago by  Jackie Lowery.