02-04-2016 07:58 AM
Hi, we are backing up a server with 3 mount points which each contain an instance of SQL. As you can see from the backup output, each instance is overwriting the last backup file (using the same backup destination file)
Any way around this ?
Drives and backup destinations:
D:\SQL_DATA\A..NTROL\LOGS_DATA (D:\SQL_DATA\APPCONTROL\LOGS_DATA\) to \\workstation\backup\LOGS_DATA_Drive.v2i
D:\SQL_DATA\A..ONTROL\SNAPINFO (D:\SQL_DATA\APPCONTROL\SNAPINFO\) to \\workstation\backup\SNAPINFO_Drive.v2i
D:\SQL_DATA\A..ROL\SYSTEM_DATA (D:\SQL_DATA\APPCONTROL\SYSTEM_DATA\) to \\workstation\backup\SYSTEM_DATA_Drive.v2i
D:\SQL_DATA\A..NTROL\USER_DATA (D:\SQL_DATA\APPCONTROL\USER_DATA\) to \\workstation\backup\USER_DATA_Drive.v2i
D:\SQL_DATA\AV\LOGS_DATA\ (D:\SQL_DATA\AV\LOGS_DATA\) to \\workstation\backup\LOGS_DATA_Drive.v2i
D:\SQL_DATA\AV\SNAPINFO\ (D:\SQL_DATA\AV\SNAPINFO\) to \\workstation\backup\SNAPINFO_Drive.v2i
D:\SQL_DATA\AV\SYSTEM_DATA\ (D:\SQL_DATA\AV\SYSTEM_DATA\) to \\workstation\backup\SYSTEM_DATA_Drive.v2i
D:\SQL_DATA\AV\USER_DATA\ (D:\SQL_DATA\AV\USER_DATA\) to \\workstation\backup\USER_DATA_Drive.v2i
D:\SQL_DATA\LCS\LOGS_DATA\ (D:\SQL_DATA\LCS\LOGS_DATA\) to \\workstation\backup\LOGS_DATA_Drive.v2i
D:\SQL_DATA\LCS\SNAPINFO\ (D:\SQL_DATA\LCS\SNAPINFO\) to \\workstation\backup\SNAPINFO_Drive.v2i
D:\SQL_DATA\LCS\SYSTEM_DATA\ (D:\SQL_DATA\LCS\SYSTEM_DATA\) to \\workstation\backup\SYSTEM_DATA_Drive.v2i
D:\SQL_DATA\LCS\USER_DATA\ (D:\SQL_DATA\LCS\USER_DATA\) to \\workstation\backup\USER_DATA_Drive.v2i
02-05-2016 01:58 AM
Can you post a screenshot of the backup job configuration?
02-05-2016 02:27 AM
What version of SSR are you using (confirm version details in Help/About)? And what operating system?
An understanding of how the mount points are configured would also help.
02-10-2016 07:24 AM
ITs version 2003 R2 - i'm not really sure how its setup ont he SAN. I just know we have a folder on the D: with mount points to the SAN. Dunt know why it uses the same names/folders.
02-10-2016 02:37 PM
Can you post a screenshot of the backup job configuration?
02-11-2016 04:38 AM
02-11-2016 06:47 AM
I think this will require a support case in order to figure out what is going on here. Log analysis will probably be needed along with a closer look at the configuration of your server.
02-11-2016 07:35 AM
Damn, we were evaluating the software for a major migration as well. Looks like we'll need to find an alternative.