URLs

http://www.asp.net/sql-server/videos
http://www.learnvisualstudio.net/- Snapshot
http://www.flag.com.tw/book/cento-5105.asp?bokno=F6222&id=169


Microsoft SQL Server 認證
http://www.microsoft.com/taiwan/learning/certification/cert-sql-server.mspx

[Table] 備份維護計畫

USE [MSDB]

sysmaintplan_plans
sysmaintplan_subplans
sysmaintplan_log
sysmaintplan_databases



BACKUP DATABASE [OverTime] TO  DISK = N'E:\Backup\SQL\OverTime\OverTime_backup_201104150931.bak' WITH NOFORMAT, NOINIT,  NAME = N'OverTime_backup_20110415093118', SKIP, REWIND, NOUNLOAD,  STATS = 10

EXECUTE master.dbo.xp_delete_file 0,N'E:\Backup\SQL\OverTime',N'BAK',N'2011-04-01T09:33:19'