Hello Vaulter,
I have enable Volume Snapshot Shadow on the specified volume buit keep getting this error.
Failed to create SQL shadow for database [ISW-CAESAR02..caesar]. Source: isw-caesar02, Process: SQLiDA
I would appreciate further guide to fix.
Best answer by Orazan
View originalGood morning. Do you see anything in the Windows Application or System logs at the time that the database failed? Can you please tell me why you are choosing to use VSS for SQL backups?
Good morning. Do you see anything in the Windows Application or System logs at the time that the database failed? Can you please tell me why you are choosing to use VSS for SQL backups?
No, I didnt see nothing in Windows Application or system logs at the time the db failed.
I choose VSS for sql backup because I felt it will correct the error.
Do you think it is wise to use VSS for sql backup or it should be disabled?
VSS for SQL backups is usually only used in certain use cases such as DBs that are just too large to stream without issues. VSS backups while faster in backing up data, have restore limitations that streaming backups do not. Unless there is a specific use case for using VSS with SQL DB backups I would recommend to stay with streaming backups.
VSS for SQL backups is usually only used in certain use cases such as DBs that are just too large to stream without issues. VSS backups while faster in backing up data, have restore limitations that streaming backups do not. Unless there is a specific use case for using VSS with SQL DB backups I would recommend to stay with streaming backups.
Thank you.
will apply as you have said
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
