Activity overview
Latest activity by llweisscptc
SQL Prompt
I just upgraded my SQL Management Studio to v18.I previously had SQLPrompt installed on 17.9 which I uninstalled after the v18 install.I can not see how to have SQL Prompt reinstalled on v18. Via S...
Yes the account has the rights to the folders. I can copy, create and edit files and place them in that share via windows explorer without issue. / comments
Yes the account has the rights to the folders. I can copy, create and edit files and place them in that share via windows explorer without issue.
Backing up model (full database) to:
\\SANSHAREFOLDER\PATHTOBACKUPFOLDER\model.sqb
Thread 0 error:
Error 605: Error creating backup file(s). No files could be created.
Warning 200: Thread 0 warning:
Warning 200: Error creating backup file: \\SANSHAREFOLDER\PATHTOBACKUPFOLDER\model.sqb.
Warning: System error 5 (Access is denied)
SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_FBDF67A0-5B0A-4CF1-8B12-605178CF3056:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
Warning 110: Failed to save primary log file: Cannot create file "\\SANSHAREFOLDER\PATHTOBACKUPFOLDER20120110 143543 01.log". Access is denied.
Warning 110: Failed to save primary log file: Cannot create file "\\SANSHAREFOLDER\PATHTOBACKUPFOLDER20120110 143543 01.log". Access is denied.
SQL Backup exit code: 790
SQL error code: 3271
----
With windows explorer, from the target SQL Server cluster I can access the Network Share on the SAN and create, modify and delete files. SO this means all the permissions are set fine.
Still unclear why I can't access the share from within SQLBackup or SSMS. / comments
Backing up model (full database) to:
\\SANSHAREFOLDER\PATHTOBACKUPFOLDER\model.sqb
Thread 0 error:
Error 605: Error creating backup file(s). No files could be created.
Warning 200: Thread 0 warnin...
Permissions - Warning 200 and System Error 5
Same issue as others mentioned here. Maybe my situation is unique -
I am running SQL Backup on a cluster
Warning 200:
Warning 200: Error creating backup file: \\SANSHAREFOLDER\PATHTOBACKUPFOLDER\x...