tag:blogger.com,1999:blog-7258322562721325894.post4042031701282622944..comments2023-08-17T13:27:47.119+03:00Comments on How To Code: SharePoint: Manually upgrade Service Application databaseJussi Palohttp://www.blogger.com/profile/00392327346825133905noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-7258322562721325894.post-39549021603320506512018-01-12T14:59:42.909+02:002018-01-12T14:59:42.909+02:00Hi, here’s steps on how to move an SSRS install fr...Hi, here’s steps on how to move an SSRS install from 2013 farm to farm, might work for moving from 2013 to 2016, as the plumbing isn’t that different http://anothersharepointblog.com/migrating-a-sql-server-reporting-service-applicationAnonymoushttps://www.blogger.com/profile/01127207841767183397noreply@blogger.comtag:blogger.com,1999:blog-7258322562721325894.post-15640434218023572032016-12-05T02:26:46.828+02:002016-12-05T02:26:46.828+02:00good question :)))
good question :)))<br />Doombosshttps://www.blogger.com/profile/14472163079311021824noreply@blogger.comtag:blogger.com,1999:blog-7258322562721325894.post-11209452741768044172016-07-20T16:29:54.389+03:002016-07-20T16:29:54.389+03:00And what is the solution for this problem?And what is the solution for this problem?Oschudahttps://www.blogger.com/profile/17754417767715010037noreply@blogger.comtag:blogger.com,1999:blog-7258322562721325894.post-78415356762987630662016-07-19T11:50:04.098+03:002016-07-19T11:50:04.098+03:00You cannot use this command to Provision SQL Serve...You cannot use this command to Provision SQL Server Reporting Services databases. It can only be used for SharePoint Service Application databases.Jussi Palohttps://www.blogger.com/profile/00392327346825133905noreply@blogger.comtag:blogger.com,1999:blog-7258322562721325894.post-56273465057830989012015-10-11T04:58:19.563+03:002015-10-11T04:58:19.563+03:00Yes, same here. One 3 of 4 SP server, all 3 Repor...Yes, same here. One 3 of 4 SP server, all 3 Reporting Services databases are reporting Database is in compatibility range and upgrade is recommended. When I run get-spdatabase, only the tempDB is returned.<br /><br />Exception calling "Provision" with "0" argument(s):<br />"ReportingServices_TempDB on spsql contains user-defined schema.<br /> Databases must be empty before they can be used. Delete all of the tables,<br />stored procedures and other objects or use a different database."<br />At line:1 char:1<br />+ $db.provision()<br />+ ~~~~~~~~~~~~~~~<br /> + CategoryInfo : NotSpecified: (:) [], MethodInvocationException<br /> + FullyQualifiedErrorId : SPUncleanDatabaseExceptionKurthttps://www.blogger.com/profile/08848527962853586650noreply@blogger.comtag:blogger.com,1999:blog-7258322562721325894.post-28561735472551309712015-04-03T05:55:14.282+03:002015-04-03T05:55:14.282+03:00Having the same issue with this command.
Having the same issue with this command.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7258322562721325894.post-30066244796934316382015-02-03T23:59:40.829+02:002015-02-03T23:59:40.829+02:00I tried using this to upgrade my SearchLinksDataba...I tried using this to upgrade my SearchLinksDatabase, SearchAdminDatabase, SearchGathererDatabase and SearchAnalyticsReportingDatabase databases but it I get the following error:<br />Exception calling "Provision" with "0" argument(s):<br />"Search_Service_Application_LinksStoreDB_5970c6564d124d11a7666bac8b502c31 on<br />sp13be contains user-defined schema. Databases must be empty before they can<br />be used. Delete all of the tables, stored procedures and other objects or use<br />a different database."<br /><br />Any idea how I can upgrade these databases please?Anonymousnoreply@blogger.com