w********i 发帖数: 244 | 1 How to restore the big .bak(75G)file from one server to another server in
sql server 2008?
Thank you! |
s**********o 发帖数: 14359 | 2 server to another server是怎么连接的,DOMAIN NETWORK,什么速度啊,
速度慢只能去LOCAL RESTORE,否则要好长时间,100MB的网速估计都要很久,
如果是VPN啥的,根本就不可能了。
【在 w********i 的大作中提到】 : How to restore the big .bak(75G)file from one server to another server in : sql server 2008? : Thank you!
|
A*********n 发帖数: 637 | 3 compress and move to another server local, then restore.
next time when back-up, use 3rd party software to compress can help...or use
sql server native compression.
【在 w********i 的大作中提到】 : How to restore the big .bak(75G)file from one server to another server in : sql server 2008? : Thank you!
|
s**********o 发帖数: 14359 | 4 一压一解需要不少空间的,2008要ENTERPRISE VERSION才有COMPRESSED BACKUP
use
【在 A*********n 的大作中提到】 : compress and move to another server local, then restore. : next time when back-up, use 3rd party software to compress can help...or use : sql server native compression.
|
A*********n 发帖数: 637 | 5 don't tell me LZ' 2008 is not enterprise version. OK, if it's not, use 3nd
party tool.
Need more space during compression and uncompressed? how many? double? even
double it's 150g, don't tell me the drive doesn't have that much, then I
have no comments.
【在 s**********o 的大作中提到】 : 一压一解需要不少空间的,2008要ENTERPRISE VERSION才有COMPRESSED BACKUP : : use
|
w********i 发帖数: 244 | 6 The SQL server version is following:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:
46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on
Windows NT 6.1 (Build 7601: Service Pack 1)
Do you know any 3rd party tools? Thank you very much!
The bak file is 75G in Prod Server. I need to restore it to the test server.
I copy this 75G file to the test server. After that, there is only 18G left
in Test Server. Is it ok? Thank you very much!!! |
s**********o 发帖数: 14359 | 7 你的PROD BACKUP不会是LOCAL的吧,原则是要BACKUP 到NETWORK专门的BACKUP SERVER
上,
然后一样的RESTORE TEST SERVER上,LOCAL BACKUP STORAGE坏掉了,那么BACKUP也没
了,
有啥意义 |
p********l 发帖数: 279 | 8 Backup compression is available in 2008 R2 standard edition, too. |