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

Task #813436: 1 STAGE 環境建置

2. db 建置

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

Status:
Resolved
Priority:
Normal
Assignee:
Start date:
2019-04-22
Due date:
2019-04-26
% Done:

100%

Estimated time:
2.00 h
Sequencing:

History

#1 Updated by 月瓊 許 almost 3 years ago

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

#2 Updated by 月瓊 許 almost 3 years ago

  • Assignee set to 月瓊 許

#3 Updated by 月瓊 許 almost 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

#4 Updated by 月瓊 許 almost 3 years ago

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

#5 Updated by 月瓊 許 almost 3 years ago

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

#6 Updated by 月瓊 許 almost 3 years ago

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

#7 Updated by 月瓊 許 almost 3 years ago

#8 Updated by 月瓊 許 almost 3 years ago

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

#9 Updated by 月瓊 許 almost 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

#10 Updated by Kevin Fu over 2 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

#11 Updated by Kevin Fu over 2 years ago

  • Assignee changed from Kevin Fu to 月瓊 許

Also available in: Atom PDF