Log Shipping Monitoring and Troubleshooting

Log Shipping Monitoring and Troubleshooting 交易紀錄傳送監控與疑難排解 1.Log Shipping status View the Log Shipping Report (SQL Server Management Studio) https://msdn.microsoft.com/en-us/library/ms181149.aspx To display the Transaction Log Shipping Status report on a server instance Connect to a monitor server, primary server, or secondary server. Right-click the server instance in Object Explorer, point to Reports, and point to Standard…

0

SQL Server Learning Resource

SQL Server 學習資源 中英文官方線上課程 Microsoft Virtual Academy Database Development Course https://mva.microsoft.com/training-topics/database-development#!jobf=Developer&lang=1033 必學的 SQL Server 2014 資料庫管理技巧 https://mva.microsoft.com/zh-tw/training-courses/-sql-server-2014–11125 SQL Server 管理入門 (一):安裝、設定與連線 https://mva.microsoft.com/zh-tw/training-courses/sql-server–11718?l=Pym6n7iEB_9804984382 SQLPASS http://www.sqlpass.org/ 線上研討會 研討會錄影檔會放到youtube High Availabilty Disaster Recovery Virtual Chapter https://www.youtube.com/channel/UCVXM_bmBuTEln3K4GHeuBAQ SQLPASS Taiwan https://www.facebook.com/groups/sqlpasstaiwan/ 每個月舉辦研討會 Super SQL Server https://www.facebook.com/groups/222546864546011/ 不定期舉辦線上研討會課程 Tutorials SQL Server 2008 R2 https://msdn.microsoft.com/en-us/library/ms167593(v=sql.105).aspx SQL Server技術文件 SQL Server 2008 R2 -…

0

File xxx.ps1 cannot be loaded because the execution of scripts is disabled on this system. Please see get-help about_signing

PS C:\Temp>.\myPS.ps1 C:\Temp\myPS.ps1 檔案無法載入,因為這個系統上已停用指令碼執行。如需詳細資訊,請參閱 “get-help about_signing”。 位於 行:x 字元:xx + .\myPS.ps1 <<<< + CategoryInfo          : NotSpecified: (:) [], PSSecurityException + FullyQualifiedErrorId : RuntimeException File C:\Temp\myPS.ps1 cannot be loaded because the execution of scripts is disabled on this system. Please see “get-help about_signing” for more details. Resolution: PS C:\Users\Administrator>Set-ExecutionPolicy RemoteSigned Using the Set-ExecutionPolicy Cmdlet https://technet.microsoft.com/en-us/library/ee176961.aspx Restricted…

0