Nice article. However, I had to come up with something like this as well and choose mirrorring because the client wanted to be able to swtich the app as part...

Hi Everybody :

Something was edited on my original submission, which was as follows :

declare @sql_part_one nvarchar(4000)

declare @tablename1 varchar(100)

--SET @tablename1 = 's_audit_import'

set @sql_part_one = 'MOVE \\testserver\D$\DSS\'+@tablename1+'_'+REPLACE(convert(varchar(8),getdate(), 1)+'.DAT', '/' , '')

      ...