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.
Every night, I need to copy any newly created records from this table to a similar MySQL table on another server. Here is the intended MySQL table structure:
CREATE TABLE photo ( photoId INT IDENTITY(1,1) NOT NULL, photo IMAGE, CONSTRAINT PK_photo PRIMARY KEY CLUSTERED (photoId) )
Can anyone offer some sage advice on the best way to do this? Thanks!
CREATE TABLE photo ( photoId INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, photo BLOB );
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.