December 5, 2013 at 9:32 am
Gone to back up the SSISDB and get a message 'system.data.sqlclient.SqlError: Cannot open backup device C:\.... ' Operating system error 5(Access is denied)
Now this is not the first back up taken on this instance and I only use one location to store the backups so I dont understand why I can back up one of my database to the same location as has worked for another database. They are all on the same SQL Server 2012 instance (11.0.3000) Dev edition.
Just do not understand why and its driving me Bonkers.
Cheers
E
December 5, 2013 at 9:55 am
Please double check the path where SSISDB backup is going to...
By default, SSMS will choose "C:\Program Files\Microsoft SQL Server\110\DTS\Binn" for creating the SSISDB backup, not your default Backup directory, hence it will through "Access denied" error.
December 5, 2013 at 10:04 am
I have tried a variety of destinations including just the root of C. I am convinced it is not the location
:hehe:
December 5, 2013 at 10:08 am
Well I dont know whats changed but yes the default location is different to where I backed up before. Even though I have tried about 5 different alternatives this timne it worked.
Weird, have been changing permissions and rebooting a bit so maybe that contributed to it working.
Who knows
:w00t:
Thanks
December 6, 2013 at 1:02 am
Ells (12/5/2013)
I have tried a variety of destinations including just the root of C. I am convinced it is not the location:hehe:
I have in the past seen cases where there have been security policies in place to prevent files being written to C:\ - whereas writing to anything in a subfolder worked fine. Maybe this is a factor.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply