Project

Profile

Help

HostedRedmine.com has moved to the Planio platform. All logins and passwords remained the same. All users will be able to login and use Redmine just as before. *Read more...*

Task #813440

open

Task #813436: 1 STAGE 環境建置

2. db 建置

Added by 月瓊 許 over 3 years ago. Updated over 3 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Start date:
2019-04-22
Due date:
2019-04-26 (over 3 years late)
% Done:

100%

Estimated time:
2.00 h
Sequencing:
Actions #1

Updated by 月瓊 許 over 3 years ago

  • Subject changed from 2. db 建置 to 2. db 建置
Actions #2

Updated by 月瓊 許 over 3 years ago

  • Assignee set to 月瓊 許
Actions #3

Updated by 月瓊 許 over 3 years ago

  • Due date changed from 2019-04-26 to 2019-05-03
  • Start date changed from 2019-04-22 to 2019-04-29
  • Follows Task #813439: 1. Stage 機器建置 added
Actions #4

Updated by 月瓊 許 over 3 years ago

  • Related to Task #813442: 3 程式上版 (含REDIS同步) added
Actions #5

Updated by 月瓊 許 over 3 years ago

  • Related to deleted (Task #813442: 3 程式上版 (含REDIS同步))
Actions #6

Updated by 月瓊 許 over 3 years ago

  • Precedes Task #813442: 3 程式上版 (含REDIS同步) added
Actions #7

Updated by 月瓊 許 over 3 years ago

Actions #8

Updated by 月瓊 許 over 3 years ago

  • Precedes deleted (Task #813442: 3 程式上版 (含REDIS同步))
Actions #9

Updated by 月瓊 許 over 3 years ago

  • Due date changed from 2019-05-03 to 2019-04-26
  • Start date changed from 2019-04-29 to 2019-04-22
  • Estimated time set to 2.00 h
Actions #10

Updated by Kevin Fu over 3 years ago

  • Status changed from New to Resolved
  • Assignee changed from 月瓊 許 to Kevin Fu
  • % Done changed from 0 to 100

[00:02:24] 完整備份 (3.79 GB)
[00:20:00] 複製備份檔案到本機端 (Family)
[00:50:00] 複製備份檔案到雲端 (4G 約09:40開始)
[00:03:12] 還原完整備份

下面是有用到的指令。

BACKUP DATABASE [LPS] TO DISK = N'E:\Backup\LPS.20190424.bak' WITH COPY_ONLY, NOFORMAT, NOINIT, NAME = N'LPS-完整 資料庫 備份', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10
GO

COPY \\P-LPS-DB01\E$\Backup\LPS.20190424.bak C:\Users\KevinFu\Desktop\

USE [master]
RESTORE DATABASE [LPS] FROM DISK = N'D:\Backup\LPS.20190424.bak' WITH FILE = 1, NOUNLOAD, STATS = 10
GO

Actions #11

Updated by Kevin Fu over 3 years ago

  • Assignee changed from Kevin Fu to 月瓊 許

Also available in: Atom PDF