Just realized the other day, I've been using this for over 10 years and it's still relevant! :w00t:

Mirroring does not allow for readable secondary.

In order to read the secondary for log shipping you'll have to enable STANDBY mode and there's potential that users will get...

Watch this:

TechEd: 80 minute video of Corruption Survival Techniques presentation[/url]

Some notes:

check select * from msdb..suspect_pages

Last known good dbcc check can be found by running DBCC DBINFO('[DB_NAME]') WITH TABLERESULTS and looking...

....aaaand a MS Connect to vote up: https://connect.microsoft.com/SQLServer/feedback/details/2581127

Perry Whittle (4/12/2016)

No good if the table is huge and your storage subsystem is slow. Introduces fragmentation too.

Move the files in a...

Well, I figured out a bunch of this.

If anyone's interested: http://jonmorisissqlblog.blogspot.com/2016/04/ole-db-error-ole-db-or-odbc-error-query.html

Pulled this from a trace:

RowNumber3696

EventClass39

EventSubclass5

TextDataOLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00. Trace: The SQL Server notification read operation failed. SQL Trace status code: 0.

ConnectionIDNULL

NTUserNameNULL

ApplicationNameNULL

IntegerDataNULL

StartTime4/11/16 11:17

CurrentTime4/11/16...

Move Database Files Without Taking the Database Offline

How big are your databases?

I'm a big fan of native compressed SQL backups to disk or a shared NFS which is the subsequently backed up for redundancy.

However, some databases are...

try granting access to the computer name

Access to the UNC path are going to be at the File system level on the target/share.

What are your service accounts?

Configure File System Permissions for Database Engine Access

IIRC, I used this once upon a time

http://sqlmag.com/sql-server-2000/sqlping

It all references this broken OMG it's working! link:

(...for the "Shell")

https://www.microsoft.com/download/details.aspx?id=42313

So a Visual Studio 2015 license / full install is required to do SSIS package development in SQL 2014+

...correct?

The link for Microsoft SQL Server Data Tools - Business Intelligence for...

fix the connection