Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
create trigger FixDataMC1 on MC1LINE2 after update, insert, delete as update MC1LINE2 set [Date] = REPLACE([Date], '"', ''), [Time] = REPLACE([Time], '"', ''), [VACUUM_PRESS.] = REPLACE([VACUUM_PRESS.], ',', '') update MC1LINE2 set [Date] = '20' + [Date] where LEN([Date]) <=8 delete from MC1LINE2 where [No.] like '%No.%' go
BULK INSERT vw_bulk_insert_test FROM '\\172.27.10.11\MC1-LINE #2\MC01-2013-0120-0448.csv' WITH ( FIELDTERMINATOR =',', ROWTERMINATOR = '\n', FIRE_TRIGGERS )
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!