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.
byte bytes = new byte[file.ContentLength]; file.InputStream.Read(bytes, 0, file.ContentLength);
OPEN SYMMETRIC KEY MyTableKey DECRYPTION BY CERTIFICATE EncryptMyCert INSERT INTO dbo.DocumentFiles (LetterFileId, NameFile, ContentType, Doc, FileSizeBytes, UpdateUser, updateDate) SELECT @fileId, ENCRYPTBYKEY(KEY_GUID('ArmsTableKey'),@FileName), --- this works @ContentType, ENCRYPTBYKEY(KEY_GUID('ArmsTableKey'),@doc), -- this doesnt work -- @doc, --- this works @fileSizeBytes, @username, GETDATE() END
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.