sql server 2005 的卸载和自动备份 说明
卸载：执行命令c:\sqlserver2005\Setup.exe /qb REMOVE=ALL INSTANCENAME=<InstanceName>
其中，setup.exe是SQLEXPR_ADV.EXE解压缩之后的安装程序。
之所以这么做，是因为在控制面板卸载时不干净，sql的实例都还在。用这个方法最好。
自动备份：
原文：http://www.mssqltips.com/tip.asp?tip=1174
思路：
1：生成一个自动备份的sql脚本，一个名叫 sp_BackupDatabase 的存贮过程。
1http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifUSE [master]
2http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifGO
3http://files.jb51.net/do/upimg/080908/1220W4252C020311063.gifhttp://files.jb51.net/do/upimg/080908/1220W4252XT032K94.gif/**//****** Object:StoredProcedure . Script Date: 02/07/2007 11:40:47 ******/
4http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifSET ANSI_NULLS ON
5http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifGO
6http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifSET QUOTED_IDENTIFIER ON
7http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifGO
8http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif
9http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif
10http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif-- =============================================
11http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif-- Author: Edgewood Solutions
12http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif-- Create date: 2007-02-07
13http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif-- Description: Backup Database
14http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif-- Parameter1: databaseName
15http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif-- Parameter2: backupType F=full, D=differential, L=log
16http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif-- =============================================
17http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifCREATE PROCEDURE [dbo].[sp_BackupDatabase]
18http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif @databaseName sysname, @backupType CHAR(1)
19http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifAS
20http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifBEGIN
21http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif SET NOCOUNT ON;
22http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif
23http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif DECLARE @sqlCommand NVARCHAR(1000)
24http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif DECLARE @dateTime NVARCHAR(20)
25http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif
26http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif SELECT @dateTime = REPLACE(CONVERT(VARCHAR, GETDATE(),111),'/','') +
27http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif REPLACE(CONVERT(VARCHAR, GETDATE(),108),':','')
28http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif
29http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif IF @backupType = 'F'
30http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif SET @sqlCommand = 'BACKUP DATABASE ' + @databaseName +
31http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif ' TO DISK = ''C:\Backup\' + @databaseName + '_Full_' + @dateTime + '.BAK'''
32http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif
33http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif IF @backupType = 'D'
34http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif SET @sqlCommand = 'BACKUP DATABASE ' + @databaseName +
35http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif ' TO DISK = ''C:\Backup\' + @databaseName + '_Diff_' + @dateTime + '.BAK'' WITH DIFFERENTIAL'
36http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif
37http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif IF @backupType = 'L'
38http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif SET @sqlCommand = 'BACKUP LOG ' + @databaseName +
39http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif ' TO DISK = ''C:\Backup\' + @databaseName + '_Log_' + @dateTime + '.TRN'''
40http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif
41http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gif EXECUTE sp_executesql @sqlCommand
42http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifEND
注意，要编译一下。
2：调用这个存储过程的一个sql脚本2。这个脚本可以被外部的程序调用，使用sqlcmd.exe来解释执行。
1http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifsp_BackupDatabase 'master', 'F'
2http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifGO
3http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifsp_BackupDatabase 'model', 'F'
4http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifGO
5http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifsp_BackupDatabase 'msdb', 'F'
6http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifGO
7http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifQUIT
3：设置定时任务，每天执行上述脚本2.
http://files.jb51.net/do/upimg/080908/1220W42523LP306339.gifsqlcmd -S serverName -E -i C:\Backup\脚本2.sql 上述语句是计划任务的“Run”里面的参数。
页:
[1]