SQL Server 2012 Databases on File Shares

Question: We are setting up a SQL Server 2012 database instance which will be hosted on a remote network share.  However, we are worried about performance over the network share.  What should we look for when setting up this database? Answer: The biggest thing that you’ll want to do is make sure that the local server and the server running the remote network share are both running the newest version of the SMB protocol.  At the very minimum you’ll want to ...

Buy This Project Plan Now!

This content is part of the Migrating to SQL Server 2012 Project Plan.

Purchase this Project Plan to receive:

  • Step-by-step guidance for managing your project, start to finish
  • Tested advice for preparing for and completing your project
  • Insights to help you avoid common pitfalls and traps

Already registered? here

Please or Register to post comments.

What's Troubleshooting SQL Server Storage Problems?

Practical advice, insight, and help for core SQL Server considerations.

Contributors

Denny Cherry

Denny Cherry has more than a decade of experience managing SQL Server and is currently the senior DBA at Phreesia. He is a Microsoft MVP and holds several Microsoft certifications, including being an...
Blog Archive