SQL Serer 2005 如何自动备份数据库.docVIP

SQL Server 2005 如何自动备份数据库 2008年12月25日 星期四 13:47 SQL Server 2005 如何自动备份数据库 具体步骤如下： ??????? 一、开始菜单中打开SQL Server Management Studio，展开窗口左边的SQL服务器； ??????? 二、SQL Server代理，右键选择启动（未启动的话）； （图1） ???????? 三、选择“作业-新建作业”； （图2） ?????? 四、在常规中输入作业的名称； （图3） ?????? 五、新建步骤，选择T-SQL，命令中输入下面语句（红色部分要根据自己的实际情况更改，D:\bak\改为自己的备份路径，databasename修改为想备份的数据库的名称） （图4） DECLARE @strPath NVARCHAR(200)set @strPath = convert(NVARCHAR(19),getdate(),120)set @strPath = REPLACE(@strPath, : , .)set @strPath = D:\bak\ + @strPath + .bakBACKUP DATABASE [databasename] TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT ??????? 六、添加计划，设置频率，时间等；（图5） 确定，完成。 ??????? 七、注意在服务里面启用 SQL Server Agent 服务。（图6） Is team-oriented and team building. Persisting in democratic centralism, improve the level of team science decision, a democratic decision. Strengthening the concept of collective leadership, by collective discussions and decisions on major issues. 5 years, between members of the team did Frank, equal treatment, mutual trust, mutual support and form a innovation-oriented, democratic solidarity and diligent people, honest type of four good teams. Second, focus on the transformation of work style. Requires team members to actively think, active officers to organize work, active inspection work, initiative, by the Office and of the primary station and village (community), and make sure regardless of Division of labor and mutual support, mutual Help and complement each other, understand each other, improve leadership skills of managing. Third party organizations are weak and lax, strengthening regulation (community) party organizations and cadres, improve service levels, and enhance team effectiveness. 　　The work style of the party members and cadres in the whole town has been further changes. 2. the cadres, and improve the overall quality of party members and cadres. First, grasp the cadres team construction. Cadres of the new and improved the regulation, the town village