/* |
*功能:备份当前服务器上所有数据库,因为系统数据库和样例数据库也在sysdatabases表中, |
*它们的ID是前6个,所以加了dbid>6的条件,实际要根据服务顺上数据库的情况而定 |
*spaden 2011.4.1 |
*/ |
|
|
use master |
declare @dbname varchar (200),@bakname varchar (1000),@path varchar (1000),@datestr varchar (50) |
set @datestr= CONVERT ( varchar (12) , getdate(), 112 ) + '.bak' |
set @path='d:\' |
declare cs cursor for select name from sysdatabases where dbid>6 |
|
open cs |
FETCH NEXT FROM cs |
into @dbname |
WHILE @@FETCH_STATUS = 0 |
begin |
set @bakname=@path+@dbname+@datestr |
BACKUP DATABASE @dbname TO disk=@bakname |
FETCH NEXT FROM cs |
into @dbname |
end |
close cs |
deallocate cs |