Create Catalog (Integration Services) fails if the default backup location was changed during install - by GilaMonster

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 620992 Comments
Status Closed Workarounds
Type Bug Repros 2
Opened 11/11/2010 6:29:27 AM
Access Restriction Public


From the Denali Management studio, under SSISDB I Right clicked Integration Services and selected create catalog, typed a password, hit OK and got an error

TITLE: Microsoft SQL Server Management Studio
Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\..\Backup\SSISDBBackup.bak'. Operating system error 3(failed to retrieve text for this error. Reason: 15105).

BACKUP DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3201)

During installation I set the default backup location to C:\Databases\Backups so (even ignoring the .. that somehow found its way into the backup path) that folder does not exist

It appears that the Create for the catalog is simply using the default backup location, ignoring the possibility that it may have been changed.

In addition, selecting the Script option on the Create Catalog dialog produces a query window that simply reads
With no actual script for creating the catalog appearing
Sign in to post a comment.
Posted by PTG_Raj on 5/1/2013 at 11:14 AM
The backup file is placed in the DTS\Binn directory only if the Integration services is installed on the server!!!
Posted by ChrisPasztor on 6/24/2012 at 10:38 PM
This has been closed as fixed but no comments have been provided where the fix is located I am using release 11.0.2100. I also reviewed hot fixes in notes for cumulative update package 1 for SQL Server 2012 and can find no mention of it.