SQL Server 備份所有資料庫代碼

標籤：

今天讓我備份一下網上所有資料庫，猛地一看，幾百個呢， 坑爹呢，只好網上找找有沒有簡便的，沒想到還真有 記下來，以後好用，哈哈。。。

 

use masterdeclare @DbName varchar(60)declare @BackSql varchar(1000)declare myCursor cursor forSELECT [name] FROM SYSDATABASESwhere [name] not in (‘master‘,‘model‘,‘msdb‘,‘tempdb‘)order by [name]open myCursorfetch next from myCursor into @DbNamewhile(@@FETCH_STATUS = 0)beginif datename(weekday, getdate())=‘星期三‘ --每周三覆蓋上周三的beginselect @BackSql=‘Backup DATABASE [‘[email protected]+‘] to disk=‘‘E:\DbBackUp\‘[email protected]+‘星期三.bak‘‘ with format‘endelse--每天覆蓋上一天的beginselect @BackSql=‘Backup DATABASE [‘[email protected]+‘] to disk=‘‘E:\database\alldatabase\‘[email protected]+‘2013-06-05.bak‘‘ with format‘endexec(@BackSql)fetch next from myCursor into @DbNameendclose myCursorDEALLOCATE myCursor

　　

SQL Server 備份所有資料庫代碼