question

klunevich avatar image
klunevich asked

Will the SSISBackup.bak be over written by other SQL instances?

We have a shared server that has SQL Server 2012 installed with multiple instances. On my instance while trying to create a SSISDB catalog, I ran into an error which led to my question. The error message was "The catalog backup file 'C:\Program Files\Microsoft SQL Server\110\DTS\Binn\SSISDBBackup.bak' could not be accessed. Make sure the database file exists, and then SQL Server service account is able to access it. (Microsoft.SqlServer.IntegrationServices.Common.ObjectModel)". It turned out that SSIS was not yet installed on this server, so I am getting this done. But in the meantime, if the SSISDB in my SQL instance gets backed up to the main SQL Server default location, what will happen to it if some other instance creates a SSISDB catalog? Does mine get over written or does a version number get added or do all instances have their SSISDB info stored in the one bak file?
ssissql 2012
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I suspect this is not the location to which backups will be performed. It's probably the location from which an empty template is restored when creating a new repository. If some other instance creates a catalog, that catalog will be placed in the same directory as the master database and backups will happen in either the default backup location or the location specified in the backup command
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.