New answers tagged sql-server
You can use SSIS packages and do a data transfer to a another SQL Server. Then you can have your reports pointing to that database server.
As far as the database can be accessed through the SharePoint installed server, there is no issue if the connectivity is strong. If you need to have a secondary database which store some other data which are not used by SharePoint itself, you can use Business Connectivity Services. Having both databases in the same server is fine. But if you are planning ...
Top 50 recent answers are included