https://wiki.alikaravi.ir/index.php?action=history&feed=atom&title=Sql_Backup_Daily 2026-06-22T13:46:19Z Revision history for this page on the wiki MediaWiki 1.40.1 https://wiki.alikaravi.ir/index.php?title=Sql_Backup_Daily&diff=92&oldid=prev 2025-01-11T10:35:33Z

<p>Created page with &quot; DECLARE @path VARCHAR(256) DECLARE @DBName varchar(255) DECLARE @DATABASES_Fetch int SET @path = &#039;E:\BANK_MS_SQL_Daily\&#039; +CONVERT(VARCHAR(20),GETDATE(),112)+&#039;_&#039;+ replace(convert(varchar, getdate(),108),&#039;:&#039;,&#039;-&#039;)+&#039;\&#039; EXEC master.sys.xp_create_subdir @path DECLARE DATABASES_CURSOR CURSOR FOR select DATABASE_NAME = db_name(s_mf.database_id) from sys.master_files s_mf where -- ONLINE s_mf.state = 0 -- Only look at d...&quot;</p> <p><b>New page</b></p><div> DECLARE @path VARCHAR(256) <br /> DECLARE @DBName varchar(255)<br /> DECLARE @DATABASES_Fetch int<br /> SET @path = &#039;E:\BANK_MS_SQL_Daily\&#039; +CONVERT(VARCHAR(20),GETDATE(),112)+&#039;_&#039;+ replace(convert(varchar, getdate(),108),&#039;:&#039;,&#039;-&#039;)+&#039;\&#039;<br /> EXEC master.sys.xp_create_subdir @path<br /> DECLARE DATABASES_CURSOR CURSOR FOR<br /> select<br /> DATABASE_NAME = db_name(s_mf.database_id)<br /> from<br /> sys.master_files s_mf<br /> where<br /> -- ONLINE<br /> s_mf.state = 0 <br /> -- Only look at databases to which we have access<br /> and has_dbaccess(db_name(s_mf.database_id)) = 1 <br /> -- Not master, tempdb or model<br /> and db_name(s_mf.database_id) not in (&#039;Master&#039;,&#039;tempdb&#039;,&#039;model&#039;,&#039;HOST_ME_MMSTOOLS_LOG&#039;) <br /> group by s_mf.database_id<br /> order by 1<br /> OPEN DATABASES_CURSOR<br /> FETCH NEXT FROM DATABASES_CURSOR INTO @DBName<br /> WHILE @@FETCH_STATUS = 0<br /> BEGIN<br /> declare @DBFileName varchar(256) <br /> set @DBFileName = replace(replace(@DBName,&#039;:&#039;,&#039;_&#039;),&#039;\&#039;,&#039;_&#039;) + &#039;_&#039; + CONVERT(VARCHAR(20),GETDATE(),112) + &#039;.bak&#039;<br /> exec (&#039;BACKUP DATABASE [&#039; + @DBName + &#039;] TO DISK = N&#039;&#039;&#039;+ @path + <br /> @DBFileName + &#039;&#039;&#039; WITH NOFORMAT, INIT, NAME = N&#039;&#039;&#039; + <br /> @DBName + &#039;-Full Database Backup&#039;&#039;, SKIP, NOREWIND, NOUNLOAD, STATS = 100&#039;)<br /> FETCH NEXT FROM DATABASES_CURSOR INTO @DBName<br /> END<br /> CLOSE DATABASES_CURSOR<br /> DEALLOCATE DATABASES_CURSOR</div>

Karavi