Sql Backup Daily: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

11 January 2025

  • curprev 10:3510:35, 11 January 2025‎ Karavi talk contribs‎ 1,326 bytes +1,326‎ Created page with " DECLARE @path VARCHAR(256) DECLARE @DBName varchar(255) DECLARE @DATABASES_Fetch int SET @path = 'E:\BANK_MS_SQL_Daily\' +CONVERT(VARCHAR(20),GETDATE(),112)+'_'+ replace(convert(varchar, getdate(),108),':','-')+'\' 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..."
Retrieved from "https://wiki.alikaravi.ir/index.php?title=Sql_Backup_Daily"