1. USE [KN_online]
   
2. GO
   
3. /****** Object: StoredProcedure [dbo].[BackupDB] Script Date: 08/18/2008 09:47:26 ******/
   
4. SET ANSI_NULLS ON
   
5. GO
   
6. SET QUOTED_IDENTIFIER ON
   
7. GO
   
8. ALTER PROCEDURE [dbo].[BackupDB]
   
9. as
   
10. declare @location varchar(120)
    
11. set @location = N'c:\dbbackups\SERVERDB.bak'
    
12. 
    
13. BACKUP DATABASE [Kn_Online] TO DISK = @location WITH NOFORMAT, INIT, NAME = N'KO-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
    
14. declare @backupSetId as int
    
15. select @backupSetId = position from msdb..backupset where database_name=N'Kn_Online' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'Kn_Online' )
    
16. if @backupSetId is null begin raiserror(N'Verify failed. Backup information for database ''Kn_Online'' not found.', 16, 1) end
    
17. RESTORE VERIFYONLY FROM DISK = @location WITH FILE = @backupSetId, NOUNLOAD, NOREWIND

复制代码

this proc is usefull because u can easily attach it to a php file, and make something like a: *Backup Tool*
使用这个进程你可以轻易的在PHP网页中实现备份数据库的功能

...............看不懂