June 26, 2008 at 1:30 pm
Hi,
I have a task to perform a backup of 6 tables from one server to another server using SSIS packages.I will explain the scenerio clearly
suppose I have six tables on server1------1)table1
2)table2
3)table3
4)table4
5)table5
6)table6
now I need to take a backup of all these six tables into another server called server2 and the names of these tables in the server2 must be ending with date or time stamp so that we can identify them according to dates like for suppose the backed up tables in server2 should look and named as
server2
1)table1_2008_06_25
2)table1_2008_06_26
3)table1_2008_06_27
4)table1_2008_06_28
5)table1_2008_06_29
6_table1_2008_06_30
now on 29th of june the table on 25th should be deleted so that only th back up for previous 2 days stays on the server2.
can anyone please suggest me steps to this .
Thank you for all in advance
June 26, 2008 at 1:44 pm
use the Transfer SQL Server Objects Task in SSIS.
also use a VBScript or a T-SQL
http://www.sqlservercentral.com/Forums/Topic451801-8-1.aspx
Maninder
www.dbanation.com
June 26, 2008 at 2:44 pm
you'll need to build scripting into your process to append the date to the name as well as delete the old ones. I'd make these two separate processes, one calling the other.
June 26, 2008 at 3:41 pm
Thank you
but can you tell me wat script to be used and also these tables are on different table so how do I call them ,I mean what is the naming convention to call tables from different servers working on a different server
June 26, 2008 at 4:11 pm
Can you please tell me how you build these as two separate processes
and also what scripts are involved and also how do u call them
can you please give me a step wise procedure to do all this
Thank you
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply