Changes for page migrate to managed instance
Last modified by Rudi Marais on 2024/03/28 18:51
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -30,6 +30,34 @@ 30 30 31 31 * no encrypted objects, they need to be decrypted or removed prior to exporting. 32 32 33 + 34 +SQL 2012 35 + 36 + 37 + 38 +EXEC sp_configure 'show advanced options', 1; 39 +GO 40 +RECONFIGURE; 41 +GO 42 + 43 +EXEC sp_configure 'xp_cmdshell',1 44 +GO 45 +RECONFIGURE 46 +GO 47 + 48 + 49 +EXEC XP_CMDSHELL 'net use O: ~\~\zagpebslab.file.core.windows.net\sqlshare /user:"localhost\zagpebslab" "access_key"' 50 + 51 +EXEC XP_CMDSHELL 'Dir O:' 52 + 53 + 54 +BACKUP DATABASE Everest_TEST 55 +TO DISK = N'O:\ENS_Everest_Test_20230721_1806.bak' 56 +WITH COMPRESSION; 57 +GO 58 + 59 + 60 + 33 33 = Importing = 34 34 35 35