由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - How to restore the big .bak(75G)file from one server to another server in sql server 2008
相关主题
总结一下SQL SERVER的DISASTER RECOVERY PLAN吧journal for sql server
求助,backup/disaster recovery plan.啥时候你忘了做备份了, 啥时候你就悲剧了
MySQL questionOracle Server for Windows 2000 -- 新手求助
about installation of oracle9iMS SQL Enterprise Manager - A connection could not be established to 'servername'
XML ZIP COMPRESSION RATIO问题Re: HELP: How to restore SQL server 7 backup file to SQL server 2000?
HELP: How to restore SQL server 7 backup file to SQL server 2000?[紧急]求助。关于MSSQL Rollback问题
发包子,每周一题sql server 2005 问题
请问Enterprise level experienceMS SQL Server 2005的安装问题
相关话题的讨论汇总
话题: server话题: 75g话题: restore话题: bak话题: sql
1 (共1页)
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.
1 (共1页)
相关主题
MS SQL Server 2005的安装问题XML ZIP COMPRESSION RATIO问题
问个SQL Server version的问题HELP: How to restore SQL server 7 backup file to SQL server 2000?
在sql server 中存储中文的问题发包子,每周一题
DB Restore through WAN?请问Enterprise level experience
总结一下SQL SERVER的DISASTER RECOVERY PLAN吧journal for sql server
求助,backup/disaster recovery plan.啥时候你忘了做备份了, 啥时候你就悲剧了
MySQL questionOracle Server for Windows 2000 -- 新手求助
about installation of oracle9iMS SQL Enterprise Manager - A connection could not be established to 'servername'
相关话题的讨论汇总
话题: server话题: 75g话题: restore话题: bak话题: sql