0916

GDS
blog
Xmind
Trello

-----------------------------------
* M2432 VM 轉移 SOP test ok 9/16
1. install driver again
2. 橋接網路 choose NAT (not NAT 網路)
3. IP4 網路 改 自動取得 IP
4. 共用資夾 改 J:
-----------------------------------
9/10 刷卡說明 & PC ID 共用槽
9/11 VM build - test 龜 & classroom ok
web
共用夾
D:
9/12 sql server 2012 install
9/16 sql server db 資料庫備份與還原 與 操作
還原比較容易出錯 (還原演練; 災難復原計畫)


=========TSQL 程式碼==============

use [master]
-- 開啟 xp_cmdshell
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'xp_cmdshell', 1;
GO
RECONFIGURE;
GO 

--宣告變數
DECLARE @FolderName nvarchar(100) 
DECLARE @FileName nvarchar(100)
DECLARE @BackupFolderName nvarchar(100)
DECLARE @FileDate nvarchar(100)
DECLARE @DataBaseName nvarchar(100)
DECLARE @JobName nvarchar(100)
DECLARE @Command nvarchar(100)

--設定變數
------ 要改的地方 以下 name & 路徑
SET @DataBaseName = 'db1'
SET @BackupFolderName = 'D:\dbbackup\sql2012'
------ 要改的地方 以上 name & 路徑

SET @JobName = @DataBaseName + ' 備份'

--取得日期變數 , 例 2013-01-01 12:30:40.001
SET @FileDate = CONVERT(nvarchar(100), GETDATE(), 121)

--除去日期變數中的 - : . 符號 , 例 20130101_123040_001
SET @FileDate = REPLACE( @FileDate , '-' , '' )
SET @FileDate = REPLACE( @FileDate , ':' , '' )
SET @FileDate = REPLACE( @FileDate , '.' , '_' )
SET @FileDate = REPLACE( @FileDate , ' ' , '_' )

--設定備份目錄,並自動以年、月建立目錄
SET @FolderName = @BackupFolderName
SET @Command = 'mkdir ' + @FolderName
EXEC xp_cmdshell @Command, no_output

SET @FolderName = @FolderName + '\' + @DataBaseName 
SET @Command = 'mkdir ' + @FolderName
EXEC xp_cmdshell @Command, no_output

SET @FolderName = @FolderName + '\' + SUBSTRING(@FileDate , 1 , 4)
SET @Command = 'mkdir ' + @FolderName
EXEC xp_cmdshell @Command, no_output

SET @FolderName = @FolderName + '\' + SUBSTRING(@FileDate , 5 , 2)
SET @Command = 'mkdir ' + @FolderName
EXEC xp_cmdshell @Command, no_output

--設定檔案名稱
SET @FileName = @FolderName + '\' + @DataBaseName  + '_' + SUBSTRING(@FileDate , 1 , 15) + '.bak'

--執行備份作業
BACKUP DATABASE @DataBaseName TO DISK = @FileName WITH NOINIT , NOUNLOAD , NAME = @JobName , NOSKIP , STATS = 10, NOFORMAT


-- 關閉 xp_cmdshell
use [master]
EXEC sp_configure 'show advanced options', 0;
GO
EXEC sp_configure 'xp_cmdshell', 0;
GO
RECONFIGURE;
GO 

==========TSQL 程式碼============