looking for a script ?

don`t have a vendor, the DB ahs 5 tables and i just wanted to archive some old data in to another db .

its a databse with 5 tables , i want archive 2 or 3 years old data in to another database.

hi,

what do think if i get bex to backup the database on the secondary server? would it work because its stanby server contantly restoring database. i mean the DB are...

Any other way to setup logshipping ? because it sound like ihave to do this every morning. can i tell BEx to not backup the .ldf file? would it...

This is what i get. what do you think?

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805103001.trn2008-08-05 11:30:01.00013024800000000460000130248000000035700001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805101501.trn2008-08-05 11:15:01.00013024700000003850000130248000000004600001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805100000.trn2008-08-05 11:00:00.00013024700000002440000130247000000038500001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805094500.trn2008-08-05 10:45:00.00013024700000001710000130247000000024400001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805093000.trn2008-08-05 10:30:00.00013024700000000310000130247000000017100001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805091500.trn2008-08-05 10:15:00.00013024500000003950000130247000000003100001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805090001.trn2008-08-05 10:00:01.00013024500000003290000130245000000039500001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805084501.trn2008-08-05 09:45:01.00013024500000002760000130245000000032900001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805083001.trn2008-08-05 09:30:01.00013024500000002580000130245000000027600001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805081504.trn2008-08-05 09:15:04.00013024500000001660000130245000000025800001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805080001.trn2008-08-05 09:00:01.00013024500000001430000130245000000016600001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805074501.trn2008-08-05 08:45:01.00013024500000001180000130245000000014300001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805073001.trn2008-08-05 08:30:01.00013024500000001140000130245000000011800001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805071501.trn2008-08-05 08:15:01.00013024500000000830000130245000000011400001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805070001.trn2008-08-05 08:00:01.00013024500000000700000130245000000008300001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805064501.trn2008-08-05 07:45:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805063001.trn2008-08-05 07:30:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805061501.trn2008-08-05 07:15:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805060001.trn2008-08-05 07:00:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805054501.trn2008-08-05 06:45:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805053001.trn2008-08-05 06:30:01.00013024500000000700000130245000000007000001CL-SQL1\Administrator

\\cl-sql1\TFHertsLogs\TFHERTSUNI_20080805051501.trn2008-08-05...

I have run the script and come with nothing (no rows effected)

I am getting these error

Date04/08/2008 20:20:00

LogWindows NT (Application)

SourceSQLSERVERAGENT

CategoryJob Engine

Event1073742032

ComputerDH-SQL1

Message

SQL Server Scheduled Job 'LSAlert_dh-SQL1' (0xE7C7FFB97CA2F14D9300B32A2925D5AB) - Status: Failed - Invoked on: 2008-08-04 20:20:00 - Message: The job failed. The Job...

No, i don`t have logbackup. the onlything i got running is BEX agent doing a bckup all .mdf and .ldf files on the primary server.