谢谢
解决方案 »
- SQL SERVER 2005 复制技术 设置快照代理安全性 头着急要试验结果哪位高人帮忙看看,谢谢了。。。
- 100年前的第一个月第一天怎么得到
- 如何理解这句话(数据库概念)?
- SQL Server数据怎么导出为SQL语句?
- reporting services 的一个问题,请教大家一下
- 散粉: 送大家三个辅助按周(星期日是周的最后一天)汇总的自定义函数!
- 父子表视图建索引问题
- 关于3台服务器数据库实时同步的问题
- SQL SERVER 里一个好麻烦的查询,讨论的也可以来
- SQL SERVER 2008 怎么查询程序对数据库的操作记录?
- Sql查询问题,很奇怪的
- 提取第8行记录到第16条记录的sql语句怎么写?
一個作完全备份再在系統裡設定排程計劃
下面是一個完全備份例子:
backup.bat
-----------------------
F:
cd \
cd sql"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql" -U sa -P turbo -S Servername -i backup.sqlset WEEK=%errorlevel%
:ZIP
"C:\Program Files\WinRAR\Rar.exe" a e:\test\smepos%WEEK% e:\test\aa.dat
del e:\test\aa.dat
pause
:END
echo DONE!backup.sql
----------------------------
backup database XXXXX to disk='e:\test\test.dat'
GO
exit(select DatePart(weekday, getdate())-1)其中的DB名,路徑等自己改一下就行了
---------------------
E:
cd \
cd test"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql" -U sa -P turbo -S Servername -i backupall.sql
set WEEK=%errorlevel%if "%WEEK%"=="0" goto ZIP_FULL
:ZIP_DIFF
del e:\test\db_diff%WEEK%.rar /q
del e:\test\sys_full%WEEK%.rar /q
"C:\Program Files\WinRAR\Rar.exe" a e:\test\db_diff%WEEK% e:\test\*.diff
"C:\Program Files\WinRAR\Rar.exe" a e:\test\sys_full%WEEK% e:\test\*.full
del e:\test\*.diff
del e:\test\*.full
goto END
:ZIP_FULL
del e:\test\db_full%WEEK%.rar /q
"C:\Program Files\WinRAR\Rar.exe" a e:\test\db_full%WEEK% e:\test\*.full
del e:\test\*.full
goto END
:END
copy e:\test\db_diff%WEEK%.rar h:\test
copy e:\test\sys_full%WEEK%.rar h:\test
copy e:\test\db_full%WEEK%.rar h:\test
echo DONE!
------------------------------------------------------------------------
backupall.sql
---------------------------
declare @file varchar(100)
declare @backup_path varchar(30)
declare @week char(1)
declare @ext varchar(5)set @backup_path='e:\test\'
select @week=DatePart(weekday, getdate())-1-- 星期日才做完整備份, 其他只做差異性備份
if @week = 0
set @ext = '.full'
else
set @ext = '.diff'
declare cursor1 cursor for
select name from master.dbo.SysDatabases
declare @db_name varchar(20)
declare @cmd varchar(8000)
--set @cmd = ''
open cursor1
fetch cursor1 into @db_name
while(@@FETCH_STATUS = 0) begin
set @file =@backup_path + @db_name + @ext
if @week = 0 -- 星期天完整備份
backup database @db_name to disk=@file with INIT
else
backup database @db_name to disk=@file with INIT,differential fetch cursor1 into @db_name
end
close cursor1
deallocate cursor1set @db_name = 'msdb'
set @file =@backup_path + @db_name + '.full'
backup database @db_name to disk=@file with INITset @db_name = 'master'
set @file =@backup_path + @db_name + '.full'
backup database @db_name to disk=@file with INIT-- 傳回星期幾
exit(select DatePart(weekday, getdate())-1)