摘要:
/*--说明:下面的代码演示了如何利用日志还原功能,将主数据库中的数据变化及时反馈到备用数据库中备用数据库的数据可以随时用于查询,但不能被更新(备用数据库只读)。--*/--首先,创建一个演示用的数据库(主数据库)CREATE DATABASE Db_testON( NAME = Db_test_DATA, FILENAME = 'c:\Db_test.mdf' )LOG ON ( NAME = Db_test_LOG, FILENAME = 'c:\Db_test.ldf')GO--对数据库进行备份BACKUP DATABASE Db_test TO DISK 阅读全文
posted @ 2012-05-21 18:56
读书
阅读(196)
评论(0)
推荐(0)
摘要:
--创建一个测试的数据库CREATE DATABASE dbGO--创建两个登录EXEC sp_addlogin 'aa'EXEC sp_addlogin 'bb'--设置登录的默认数据库为测试数据库 dbEXEC sp_defaultdb 'aa','db'EXEC sp_defaultdb 'bb','db'GO--授予登录访问数据库的权限(将登录设置为数据库的用户)USE dbEXEC sp_grantdbaccess 'aa'EXEC sp_grantdbaccess 阅读全文
posted @ 2012-05-21 18:55
读书
阅读(199)
评论(0)
推荐(0)
摘要:
--Initialize the backup file and backup the SmallWorks database to the fileBACKUP DATABASE SmallWorks TO DISK = 'E:\SQLBackups\SmallWorksBackups.BAK'WITH INIT, DESCRIPTION = 'Full Backup of SmallWorks'--Send an Additional backup to the fileBACKUP DATABASE SmallWorks TO DISK = 'E: 阅读全文
posted @ 2012-05-21 17:37
读书
阅读(175)
评论(0)
推荐(0)
摘要:
using System;using System.IO;using System.Security.Cryptography;using System.Text;namespace APress.DotNetSecurity.Chapter2.PDBSample{class PDBSampleTester{static void Main(string[] args){try{Console.WriteLine("Creating the salt...");RNGCryptoServiceProvider rng = new RNGCryptoServiceProvid 阅读全文
posted @ 2012-05-21 17:34
读书
阅读(165)
评论(0)
推荐(0)
摘要:
1#2# This is a verbose template for generic NASL scripts.3#45#6# Script Title and Description7#8# Include a large comment block at the top of your script9# indicating what the script checks for, which versions10# of the target software are vulnerable, your name, the11# date the script was written, c 阅读全文
posted @ 2012-05-21 10:56
读书
阅读(168)
评论(0)
推荐(0)
摘要:
using System;using System.IO;using System.Security.Cryptography;using System.Text;namespace APress.DotNetSecurity.Chapter2.AsymmetricAlgorithmEncryptor{class AsymmetricAlgorithmEncryptorTester{static void Main(string[] args){try{String adPath = AppDomain.CurrentDomain.SetupInformation.ApplicationBas 阅读全文
posted @ 2012-05-21 10:06
读书
阅读(292)
评论(0)
推荐(0)
摘要:
using System;using System.IO;using System.Security.Cryptography;using System.Text;namespace APress.DotNetSecurity.Chapter2.ExcludingRNG{class ExcludingRNGTester{static void Main(string[] args){try{byte[] randomExcludedData = new byte[255];byte[] excludedData = {1, 2, 3, 4, 5, 6, 7, 8, 9, 0};Console. 阅读全文
posted @ 2012-05-21 10:02
读书
阅读(152)
评论(0)
推荐(0)
摘要:
using System;using System.IO;using System.Security.Cryptography;using System.Text;namespace APress.DotNetSecurity.Chapter2.SymmetricAlgorithmEvaluator{class SymmetricAlgorithmEvaluatorTester{static void Main(string[] args){try{Console.WriteLine("Creating a RijndaelManaged instance...");Sym 阅读全文
posted @ 2012-05-21 10:02
读书
阅读(180)
评论(0)
推荐(0)

浙公网安备 33010602011771号