December 13, 2011 at 10:37 am
Hello All,
I use maintenance plans for backups. The maintenance plan also deletes files older than 3 days.
I have a new requirement to additionally copy backup files to a different folder for synching offsite to a DR location. To minimize disk space the request is to only have the most recent backup and any subsequent transaction log backups (no diffs are involved).
How can I add a step to my normal backup job that would compare my normal backup location and the new dr/synch location and make sure ther were no files in the dr/synch location older than my most recent full?
Thank if you can help!
December 13, 2011 at 10:44 am
I would use robocopy to mirror the two folders. It will delete files at the destination as they are delete at the source.
The probability of survival is inversely proportional to the angle of arrival.
December 13, 2011 at 10:46 am
My source is going to have three days, my new destination folder should just have the latest full and subsequent trans.
December 13, 2011 at 10:59 am
better option would be to use scripted T-SQL jobs, the BACKUP DATABASE command has a MIRROR TO clause which can be used to mirror backups. A lightweight VB script can then be used to prune the remote files
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2011 at 11:01 am
I would use two folders, one for the current days worth, another archive folder for the two older days. Run a local job to move the previous days files over to the archive folder right before doing the new backup. Then use robocopy to keep the main folders synchronized. Age off the archive folder at 3 days.
The probability of survival is inversely proportional to the angle of arrival.
December 13, 2011 at 11:08 am
I think MIRROR TO is only for Enterprise Edition. I am on Standard. A lightweight vb script seems like an option I'll explore that.
December 13, 2011 at 11:11 am
Chrissy321 (12/13/2011)
I think MIRROR TO is only for Enterprise Edition. I am on Standard. A lightweight vb script seems like an option I'll explore that.
Cancel that.
December 13, 2011 at 11:16 am
Am I misunderstanding the suggestion?
http://technet.microsoft.com/en-us/library/ms186865.aspx
MIRROR TO <backup_device> [ ,...n ]
Specifies a set of up to three secondary backup devices, each of which will mirror the backups devices specified in the TO clause. The MIRROR TO clause must be specify the same type and number of the backup devices as the TO clause. The maximum number of MIRROR TO clauses is three.
This option is available only in SQL Server 2005 Enterprise Edition and later versions.
December 13, 2011 at 11:21 am
Chrissy321 (12/13/2011)
Am I misunderstanding the suggestion?http://technet.microsoft.com/en-us/library/ms186865.aspx
MIRROR TO <backup_device> [ ,...n ]
Specifies a set of up to three secondary backup devices, each of which will mirror the backups devices specified in the TO clause. The MIRROR TO clause must be specify the same type and number of the backup devices as the TO clause. The maximum number of MIRROR TO clauses is three.
This option is available only in SQL Server 2005 Enterprise Edition and later versions.
Sorry, could have sworn I had done this here (Std svr)!
As suggested before, I've done this in good old dos with copy / move. Works just fine.
December 13, 2011 at 11:26 am
No worries.Your generous and informative posts have benefited my humble self many, many times.
I have xp_cmdshell available on this server and I'll explore vbscript. I'll post back when I have a solution.
December 13, 2011 at 12:24 pm
Chrissy321 (12/13/2011)
I have xp_cmdshell available on this server
No xp_cmdshell, just execute the vb script from a SQL server agent job step
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 13, 2011 at 7:18 pm
Perry Whittle (12/13/2011)
Chrissy321 (12/13/2011)
I have xp_cmdshell available on this serverNo xp_cmdshell, just execute the vb script from a SQL server agent job step
Or - look at creating a Powershell script instead of VB script. That can also be called from an agent job directly.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 14, 2011 at 1:42 am
Jeffrey Williams 3188 (12/13/2011)
Or - look at creating a Powershell script instead of VB script. That can also be called from an agent job directly.
Good call 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2012 at 4:12 pm
I have gone the SSIS route for this. I'm using this as a guide. http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/61987/
I use a for each loop container to insert files into a table from both the source and destination folders. See below for DDL and sample data.
The seed.txt files are to make the for each loop container recognize the folder if it happens to be empty at the beginning of the process.
I identify the most recent last bak file with this.
SELECT --The most full recent backup file
TOP 1 CONVERT(bigint,LEFT(RIGHT(BackupFile,16),12))
FROM dbo.BackupFiles
WHERE
BackupFileType = 'Source' AND
RIGHT(BackupFile,3) = 'bak'
ORDER BY CONVERT(bigint,LEFT(RIGHT(BackupFile,16),12)) DESC
And here is my select statement that should list all files that should be copied to the destination folder.
SELECT
BackupFile
FROM dbo.BackupFiles
WHERE
BackupFileType = 'Source' AND
CONVERT(bigint,LEFT(RIGHT(BackupFile,16),12)) >=
(
SELECT --The most full recent backup file
TOP 1 CONVERT(bigint,LEFT(RIGHT(BackupFile,16),12))
FROM dbo.BackupFiles
WHERE
BackupFileType = 'Source' AND
RIGHT(BackupFile,3) = 'bak'
ORDER BY CONVERT(bigint,LEFT(RIGHT(BackupFile,16),12)) DESC
) AND
BackupFile NOT IN
(
SELECT
BackupFile
FROM dbo.BackupFiles
WHERE
BackupFileType = 'Destination'
)
The problem. My select TOP 1 statement only returns one file and that one file is filtering the files in all folders. Logically I need to know the most recent file in each folder and then filter each folder by the most recent file within it.
I assume I need to GROUP BY each folder. But I am stuck. If my Select was working as desired these three additional files should be returned.
\\Server1\db_backup\DBServer\App2\App2_backup_201202091735.bak
\\Server1\db_backup\DBServer\App2\App2_backup_201202091825.trn
\\Server1\db_backup\DBServer\App2\App2_backup_201202091925.trn
Thanks if you can help.
--Begin DDL and sample data
CREATE TABLE [dbo].[BackupFiles](
[BackupFile] [varchar](260) NOT NULL,
[BackupFileType] [varchar](15) NOT NULL,
[Action] [varchar](6) NULL,
CONSTRAINT [PK_BackupFiles] PRIMARY KEY CLUSTERED
(
[BackupFile] ASC,
[BackupFileType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT INTO [dbo].[BackupFiles]
(BackupFile,BackupFileType)
SELECT '\\Dest_Server\db_backup\DBServer\App1\seed.txt','Destination' UNION
SELECT '\\Dest_Server\db_backup\DBServer\App2\seed.txt','Destination' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202062125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202062225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202062325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202070025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202070125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202070225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202070325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202070425.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202070525.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202070625.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202070725.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202070825.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202070925.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202071025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202071125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202071225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202071325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202071425.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202071525.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202071625.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202071725.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202071735.bak','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202071825.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202071925.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202072025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202072125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202072225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202072325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202080025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202080125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202080225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202080325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202080425.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202080525.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202080625.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202080725.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202080825.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202080925.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202081025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202081125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202081225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202081325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202081425.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202081525.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202081625.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202081725.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202081935.bak','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202081825.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202081925.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202082025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202082127.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202082225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202082325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202090025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202090125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202090225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202090325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202090425.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202090525.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202090625.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202090725.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202090825.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202090925.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202091025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202091125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202091225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202091325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202091425.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202091525.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202091625.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202091725.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202091935.bak','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202091825.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202091925.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202092025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202092127.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202092225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202092325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202100025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202100125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202100225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202100325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202100425.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202100525.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202100625.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202100725.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202100825.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202100925.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202101025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202101125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202101225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202101325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App1\App1_backup_201202101425.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202062125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202062225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202062325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202070025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202070125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202070225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202070325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202070425.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202070525.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202070625.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202070725.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202070825.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202070925.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202071025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202071125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202071225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202071325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202071425.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202071525.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202071625.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202071725.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202071735.bak','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202071825.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202071925.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202072025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202072125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202072225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202072325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202080025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202080125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202080225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202080325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202080425.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202080525.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202080625.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202080725.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202080825.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202080925.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202081025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202081125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202081225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202081325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202081425.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202081525.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202081625.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202081725.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202081735.bak','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202081825.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202081925.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202082025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202082127.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202082225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202082325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202090025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202090125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202090225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202090325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202090425.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202090525.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202090625.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202090725.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202090825.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202090925.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202091025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202091125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202091225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202091325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202091425.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202091525.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202091625.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202091725.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202091735.bak','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202091825.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202091925.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202092025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202092127.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202092225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202092325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202100025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202100125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202100225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202100325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202100425.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202100525.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202100625.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202100725.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202100825.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202100925.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202101025.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202101125.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202101225.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202101325.trn','Source' UNION
SELECT '\\Server1\db_backup\DBServer\App2\App2_backup_201202101425.trn','Source'
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply