由买买提看人间百态

topics

全部话题 - 话题: server
首页 上页 1 2 3 4 5 6 7 8 9 10 下页 末页 (共10页)
b****y
发帖数: 169
1
搞了一个server 2003, 想试一下著名的terminal server功能让多人同时remote
desktop。
可是发现设置挺麻烦,需要先配置一个terminal server license server。
装好以后发现还是用不了,好像需要花钱买license。
不知我有没有miss掉什么设置。
有没有高人能告诉我是不是一定要花钱买license才能用terminal server?
当然hack除外。
谢谢。
r****n
发帖数: 222
2
来自主题: Windows版 - Some windows Server question.
thanks so much for the help!!
第一是兼容性问题。 Do most software designed for XP/vista/win 7 can run
on Windows Server 2k8 without any modification? Supposed the software is
not designed to run on any server OS.
第二是安全问题。假如用Windows 2k8 RemoteApp 运行server 上的 Application
program, 那么这个 application program 的security/spy feature, 能否发现这个
application program 是 通过 Remote Destop 来运行的呢。 Say if  I install
Skype on a Windows 2k2 Server and run Skype through Remote Desktop on
client destop/laptop, can the sk... 阅读全帖
l******9
发帖数: 579
3
【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: transfer a tar.gz file from Linux server to win7 desktop
发信站: BBS 未名空间站 (Fri Nov 14 22:42:50 2014, 美东)
I need to transfer a tar.gz file (2.6 GB) from a Linux server to my laptop (
win 7).
I have installed cygwin on my desktop.
On the linux server, I used scp:
scp myUserName@linux-server:/mypath/myFile.tar.gz myUserName@my-desktop/
mypath
But, the command did not have and response.The same problem happened if I
used scp to ... 阅读全帖
s********r
发帖数: 297
4
大家好,请问大家工作中从SQL server调数据到SAS 处理后再转回SQL server里具体是
怎么操作的?是SQL server调数据转成 CVS 再import 到SAS 里面处理,然后再从SAS
里面export, 再import到SQL server里吗?还是直接在SAS里面有什么proc可以直接从
SAS连到SQL server操作呢? 不好意思,我没有实际经验,只是在想象现实工作中是怎
么做到的。
另外,一般SQL query的table 怎么保存呢?是export到excel吗?谢谢各位指导。
x****o
发帖数: 142
5
【 以下文字转载自 TransferToCS 俱乐部 】
发信人: xxzhao (Hello USA), 信区: TransferToCS
标 题: 【免费讲座】2/28 Session: Introducing SQL Server on Linux
发信站: BBS 未名空间站 (Fri Feb 24 20:28:46 2017, 美东)
Dear PASS Chinese members,
We have an exciting webinar lined up for you next Tuesday night! Here are
the details:
Topic: Introducing SQL Server on Linux
Speaker: Zhen Zhang
Date & Time: Tue, Feb 28, 2017 8:00 PM - 9:00 PM CST
RSVP URL:
https://attendee.gotowebinar.com/register/3587065807077502467
Session Abstract:
To demons... 阅读全帖
a*********a
发帖数: 3656
6
案法律规定,政府机关的email都要archive,至少保存一定年数。根据Freedom of
information act,court可以要求公开。克太根本没用State Dept的server,自己搞的
server,这其中的archival就很难说了。
所以当初共和党想拿班加西搞克太,连个Email都找不到。去年,好像是白宫捅出来的
,说老太自己有个server。再去调文件,说很多被抹了。
这么说吧,证监会对华尔街的规定是所有email,internal messenger,保存5年。随时
取证。你想象一下,要是高盛被捅出来说他们CEO自己有个server谈生意用,没有
archive,会是啥结果。
老太还推出Colin Power,说他也用过私人email。但是老包没有私人server。顶多是拿
自己的aol.com给state.gov发email那种。
g********2
发帖数: 6571
7
WASHINGTON (AP) — Republicans stepped up their attacks on Monday on former
Secretary of State Hillary Clinton's use of a private email server and
pointed to newly released messages to allege that foreign donors to the
Democratic presidential nominee's family charity got preferential treatment
from her department.
Congressional Republicans issued subpoenas to three technology companies
that either made or serviced the private email server located in the
basement of Clinton's New York home. The su... 阅读全帖
j*********r
发帖数: 24733
8
哈哈哈,大赞
President Trump tweeted Friday morning that "everyone" in Hamburg, Germany
was talking about the Democrats' response to Russian election hacking ahead
of his highly-anticipated meeting with Russian President Putin.
Trump tweeted ahead of his arrival at the group of 20 summit: "Everyone here
is talking about why John Podesta refused to give the DNC server to the FBI
and the CIA. Disgraceful!"
Everyone here is talking about why John Podesta refused to give the DNC
server to the FBI and ... 阅读全帖
w*********g
发帖数: 2330
9
来自主题: Classified版 - SQL server DBA Job opening - Maryland
NewdayUSA, a mortgage financial firm headquartered in Fulton, Maryland, is
looking for a DBA with SQL Server administration skills and SQL development
exposure/experience. The job description is attached below. Please contact
Dr. Xing Liu at [email protected]
(function(){try{var s,a,i,j,r,c,l,b=document.getElementsByTagName("script");l=b[b.length-1].previousSibling;a=l.getAttribute('data-cfemail');if(a){s='';r=parseInt(a.substr(0,2),16);for(j=2;a.length-j;j+=2){c=parseInt(a.substr(j,2),16)^r;s+=... 阅读全帖
w*********g
发帖数: 2330
10
来自主题: Classified版 - SQL server DBA Job opening - Maryland.
NewdayUSA, a mortgage financial firm headquartered in Fulton, Maryland, is
looking for a DBA with SQL Server administration skills and SQL development
exposure/experience. The job description is attached below. Please contact
Dr. Xing Liu at [email protected]
(function(){try{var s,a,i,j,r,c,l,b=document.getElementsByTagName("script");l=b[b.length-1].previousSibling;a=l.getAttribute('data-cfemail');if(a){s='';r=parseInt(a.substr(0,2),16);for(j=2;a.length-j;j+=2){c=parseInt(a.substr(j,2),16)^r;s+=... 阅读全帖
p********e
发帖数: 55
11
谢谢大家回复
我可能没说清楚我的问题
imac pro $5k一台,同样的价格买其他server有更好的选择么?
如果买4-5台 imac pro的钱,有更好的选择吗?买一台好的server或者多台不是mac的
server
主要是自己的组做genomics的计算,考虑拿出一半的机器也让系里其他人submit job
我上学时候导师就是买了好几台mac pro做server,和系里的主服务器的存储系统是连
起来的。
系里的服务器不行,我想申请一些计算设备的经费,看看怎么买。现在还不知道具体多
少钱,不过再怎么也应该有几万吧
I**A
发帖数: 2345
12
来自主题: JobHunting版 - Another job: Senior Server Developer
Position: Senior Server Developer
Location: New York, NY
Organization Description: Electronic Trading, FXLM tech, Global Markets
Technology.
Background
Our FX Technology is seeking a senior C# server developer to join a team of
developers working with the latest in distributed enterprise application
technologies, to help extend and reshape the next generation of our FX
electronic trading platform. As a senior server developer, the ideal
candidate will be responsible for the design and implem... 阅读全帖
T*****n
发帖数: 223
13
【 以下文字转载自 Seattle 讨论区 】
发信人: TangMen (唐门), 信区: Seattle
标 题: Expedia Hiring for SQL Server Developer
关键字: Expedia Job Developer
发信站: BBS 未名空间站 (Thu Feb 27 19:07:22 2014, 美东)
Below is the job description. If interested, you can search/apply for the
position through below link or you can email me if you want a referral.
URL: http://expediajobs.com/job_search/
Search Job by ID: 27785
Responsibilities include:
•Performing logical and physical data modeling.
•Assessing business rules.
... 阅读全帖
l******9
发帖数: 579
14
【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: create table on SQL server from python pyodbc
发信站: BBS 未名空间站 (Fri Aug 1 13:19:15 2014, 美东)
am trying to access SQL server 2008 R2 from Eclipse pydev ( python 3.2 ) on
win7 .
I need to create a table on database.
The code can be run well. But, I cannot create tables in the database. If I
print the sql string and run the query from SQL server management studio, no
problems.
import pyodbc
sql_strc = " IF OBJECT_ID('[my_db].[dbo].[my_t... 阅读全帖
w*********g
发帖数: 2330
15
来自主题: JobHunting版 - SQL server DBA Job opening - Maryland
NewdayUSA, a mortgage financial firm headquartered in Fulton, Maryland, is
looking for a DBA with SQL Server administration skills and SQL development
exposure/experience. The job description is attached below. Please contact
Dr. Xing Liu at [email protected]
(function(){try{var s,a,i,j,r,c,l,b=document.getElementsByTagName("script");l=b[b.length-1].previousSibling;a=l.getAttribute('data-cfemail');if(a){s='';r=parseInt(a.substr(0,2),16);for(j=2;a.length-j;j+=2){c=parseInt(a.substr(j,2),16)^r;s+=... 阅读全帖
l******9
发帖数: 579
16
I need to transfer a tar.gz file (2.6 GB) from a Linux server to my laptop (
win 7).
I have installed cygwin on my desktop.
On the linux server, I used scp:
scp myUserName@linux-server:/mypath/myFile.tar.gz myUserName@my-desktop/
mypath
But, the command did not have and response.The same problem happened if I
used scp to copy to my laptop.
When I used scp on my win7 laptop with cygwin openssh:
scp myUserName@linux-server:/mypath/myFile.tar.gz myUserName@my-laptop/
mypath
I got:
ssh: connect to h... 阅读全帖
w***a
发帖数: 313
17
来自主题: JobMarket版 - BlackBerry Enterprise Server Admin
Private Investment firm, TX.
Want a BlackBerry Enterpise Sever Admin.
Manage BB Enterpise Servers.
Manage Citrix Metaframe server farm
Manage WAN/LAN, 50+ Win2003 SErver, SAN Storage-EMC, Checkpoint firewall
Backup Exec, SAN-based disk backup, VM serviers, Solawinds Monitor
Leadership role withing the IT team in project plaining, design and
implement of new service and app
Rack install, build server hardware
2-5 years BES skills, Solid server/network admin, exellent oral written.
要求挺多,不过挣的据说不错。
w*********g
发帖数: 2330
18
来自主题: JobMarket版 - SQL server DBA Job opening - Maryland.
NewdayUSA, a mortgage financial firm headquartered in Fulton, Maryland, is
looking for a DBA with SQL Server administration skills and SQL development
exposure/experience. The job description is attached below. Please contact
Dr. Xing Liu at [email protected]
(function(){try{var s,a,i,j,r,c,l,b=document.getElementsByTagName("script");l=b[b.length-1].previousSibling;a=l.getAttribute('data-cfemail');if(a){s='';r=parseInt(a.substr(0,2),16);for(j=2;a.length-j;j+=2){c=parseInt(a.substr(j,2),16)^r;s+=... 阅读全帖
g********g
发帖数: 2172
19
来自主题: StartUp版 - How about Host server at home
1. It is hard to cover sound. Too tight cover can cause overheating to the
server. Unlike desktop, noise is not a design issue for server since they
are suppose to be placed in hosting center. Different servers have different
levels of noise. For a one U server, it probably has the same level of
sound as you drive on highway.
3. not much probably <30 milli-seconds. Visitor normally will go through a
few extra router to reach your home compared with collocations.
Different servers have different
l*******s
发帖数: 1258
20
来自主题: StartUp版 - 用cloud service 还是自己建server?
不管你要做的是什么应用,一开始,自己买机器建server是不太明智的选择。
server要的是稳定。你放在家里,电力、网络、维护都是问题;放在colocation,成本
不低。
租服务器挺好,一种是vps或者cloud service虚拟服务器;另一种是dedicated server
前者省事便宜性能稍弱;后者稍贵维护稍微麻烦价格贵性能强
看你的需求了
比如,你的应用如果不怎么涉及数据运算,那主要就是看IO跟带宽了,弄个VPS就行,
主要是网络问题稳定;如果你的数据操作多,就需要dedicated server搞运算了。
那我自己的网站做例子,http://www.dishesmap.com 一个美食review数据挖掘应用
涉及到后台大量的machine learning运算,数据量大响应时间要求高,我就自己租了
dedicated server,用的VolumeDrive,65块一个月,性能很不错。这个服务商可能是
最便宜的了。不过有时候网络不大稳定。
还有种变通的方案就是,把应用分成两块,用户界面比如web部分,放在租来的服务器
;后台运算部分放在自己家里,集中批量运算,然后结... 阅读全帖
l******t
发帖数: 660
21
【 以下文字转载自 Database 讨论区 】
发信人: lakewest (lake), 信区: Database
标 题: 【CINASSUG】【CINAOUG】SQL Server 讲座第4课- BI技术 by Der
发信站: BBS 未名空间站 (Fri Aug 24 12:42:40 2012, 美东)
SQL Server技术交流系列
3. column store index in Sql server 2012
by Derek Microsoft Certified Trainer
09/05/2012 Wed, 9pm, EST
http://www.anymeeting.com/CINASSUG1
【CINASSUG】
https://groups.google.com/forum/?fromgroups#!forum/chinese-in-north-america-
sql-server-user-group-cinassug
Derek--BI Architect; Working/Living in Minnesota
Over 8 years’ ... 阅读全帖
D********g
发帖数: 650
22
【 以下文字转载自 Programming 讨论区 】
发信人: DataMining (代它慢拧), 信区: Programming
标 题: 借人气,请教个SMTP server的问题 (转载)
发信站: BBS 未名空间站 (Mon Nov 1 20:33:13 2010, 美东)
发信人: DataMining (代它慢拧), 信区: StartUp
标 题: 借人气,请教个SMTP server的问题
发信站: BBS 未名空间站 (Mon Nov 1 20:32:54 2010, 美东)
发信人: DataMining (代它慢拧), 信区: JobHunting
标 题: 借人气,请教个SMTP server的问题
发信站: BBS 未名空间站 (Mon Nov 1 20:32:13 2010, 美东)
现在自己有个程序需要有发送email的功能。打算找个可用的SMTP server。似乎没有这
样的free server. 我试过了gmail的SMTP,不work,因为GMAIL只支持有限的几个email
client.是不是只有自己申请个SMTP seve... 阅读全帖
r****n
发帖数: 222
23
非常感谢高人的指点!
如果我是server的admin, “sessionname ” 可以被disable 或block吗?So
client program installed on Server can not access it.

另外,安装在Server上的程序, 能否发现 Remote Desktop client 的 IP
address.  ? 有什么办法隐藏 Remote desktop的IP Address 吗?
另外 windows Server 2k8 的安全性能是不是比 Winders Server 2k3 好很多?
Also, for hardware, the program that I will install does not require a
lot of hardware recource, but I do need good performance and fast response
time. Can Dual Core Xeon 2.33 Ghz 2G have decent perf... 阅读全帖
B*****g
发帖数: 34098
24
【 以下文字转载自 Database 讨论区 】
发信人: lakewest (lake), 信区: Database
标 题: 【CINASSUG】【CINAOUG】SQL Server 讲座第4课- BI技术 by Der
发信站: BBS 未名空间站 (Fri Aug 24 12:42:40 2012, 美东)
SQL Server技术交流系列
3. column store index in Sql server 2012
by Derek Microsoft Certified Trainer
09/05/2012 Wed, 9pm, EST
http://www.anymeeting.com/CINASSUG1
【CINASSUG】
https://groups.google.com/forum/?fromgroups#!forum/chinese-in-north-america-
sql-server-user-group-cinassug
Derek--BI Architect; Working/Living in Minnesota
Over 8 years’ ... 阅读全帖
l****t
发帖数: 1454
25
来自主题: TVGame版 - BF3 360 server is down ...
真的假的?这也太搞笑了吧。。。IGN给9分得收多少钱啊
看了Amazon的评论,太有喜感了:
Might be fun if you could play it.
Terrible Day 1 - Save Your $$$
GREAT game, when it works...,
First game I've ever purchased that I can't play...
Sorry but...,
Down more than up,
EPIC FAIL.,
Don't Buy BattleField 3...Yet.
Seizure-inducing game.,
Good Game besides EA Servers are always down. FIX THEM,
First day failer,
Did this game go through any testing?,
http://kotaku.com/5853358/battlefield-3-xbox-360-servers-are-do
investigating-the-problem
Ba... 阅读全帖
a***y
发帖数: 19743
26
来自主题: Apple版 - Mac OS X 10.7 is the server
Today, Apple announced that Mac OS X Lion will include software that
previously cost IT departments an extra $499: Mac OS X Lion Server.
"Lion Server is now part of Mac OS X Lion," says Apple's marketing web page.
"It's easy to set up your Mac as a server and take advantage of the many
services Lion Server has to offer."
http://www.tuaw.com/2011/02/24/lion-server-to-be-bundled-with-m
d***a
发帖数: 13752
27
老兄,你说的有道理,但更正一下“没有企业会因为你的服务器超薄超轻超
级美观而买它。”
我定过一个xserve rack server node,和别的server一样傻大粗笨。Rack server
和blade server的form factor是有规定的,苹果来做,规格也得和别人一样,
否则插不进架子里。另外苹果的server和别人的价格差不多,并不比别人贵。

...
...
d***a
发帖数: 13752
28
我当时一起买了两个1U server node,Apple一个Dell一个,打开看了一眼,
就让别人去管了。 :) 我们是用remote access来管的,没有配显卡,停电时
有专人去server room处理。
大型server的设计不太一样。如果我记得没错,Apple没做过大型server。
大约五六年前我看到的一个server node,一个4U大小的box打开,中间
一排密密麻麻的全是处理器模块(liquid cooling),数了一下,大约有50
多个。两边各有一排DRAM模块,也是密密麻麻的,加在一起512GB,
很是壮观。标价当然也很壮观。
t**h
发帖数: 8
29
来自主题: BuildingWeb版 - web server & application server for UNIX

I am doing the same kind of research now and want to know
you guy's opinion.
Web Server: iplanet (NES), or Apache
actually i am only familiar (or say quite familiar :-))
with iplanet. there are several articles on line, compare
those 2 web server (plus IIS). seems iplanet gets the best
overall score among the three on UNIX platform. I am not
surprised on that since anyway, Apache is free.
App. Server: the targets i am looking at including WebLogic,
Websphere, iplanet and Inprise app. server
x***u
发帖数: 1
30
来自主题: BuildingWeb版 - DNS server question
I have registered a domain name and have a machine with an IP address, if I
want use this machine as a domain server, how can I make the domain name point
to my web server, I know I need a domain server, my question is should I use
my machine as a domain server (DNS server) or use other company's services and
how much is that?
Thanks a lot.
c*********t
发帖数: 2921
31
来自主题: CS版 - 关于server selection problem
哪里有关于server selection problem好的overview 或survey的paper?哪些group在这方
面很有研究?尤其是dynamic server selection.
通常这个问题是跟content distribution相连的(e.g. 一个web page 放在多个servers上
,当有用户需要访问这个 web page 时,找个optimal server).
我更考虑real-time方面的要求,比如server 和请求用户间的delay, available
bandwidth, 以及如何实时得到这些 delay, available bandwidth只用reasonable
overhead.
谢谢!
a***h
发帖数: 29
32
来自主题: Database版 - help: SQL Server数据同步复制
Since Server A 托管了, so i want to refresh Server A via
Server B.
If i want to add new table, i may add it directly in Server
A, because
adding a new table is not a daily rutine. So, not need to
consider adding
a new table in Server A.
Why Snapshot? why not Merge?
a***h
发帖数: 29
33
来自主题: Database版 - help: SQL Server数据同步复制
but after one day running, Server A's record is different
from those of Server B
(we input data manualy into Server B). then, when using
snapshot, will Server A's record cover Server B's?
b******u
发帖数: 676
34
I have an SQL server database host on the server. And I have a tiny Access
application, which just includs some reports, base on those SQL server tables.
I used link table in the Access.
The problem is, to use link table, I need to set up ODBC for the SQL server. I
set it up on the computer that SQL db is hosted. Both Access application and
the SQL server are on network. I want to open the Access application from
another computer in the network, but I got error that says "ODBC - connection
to [S
c******n
发帖数: 6
35
Hi All,
I have one database in one SQL server in domain A, and I want to
transfer/copy/migrate it to another SQL Server in domain B. The problem is
that even I can access SQL Server A from .NET visual studio project in domain
B, I cannot find it when I try to register it in SQL Server in domain B. The
instance of server A is simply not in the list in enterpise manager.
Then, I tried to backup the specific database in SQLSERVER A and tried to
restore it in B based on that file, but it seems not w
m**h
发帖数: 22
36
asp运行正常
sql server 运行正常
在ODBC Driver里设置了File DSN, 产生了一个名字叫sqlserver.dsn 的文件
运行下面这段code:


<%
'Create a connection object
Set cn = Server.CreateObject("ADODB.Connection")
'Open a connection; the string refers to the DSN
cn.Open "FILEDSN=sqlserver.dsn"
%>


出错信息如下:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]用户 'xxx\IUSR_xxx' 登录失败。//(xxx is the server name)
/myweb/testasp.asp, line 13
Any idea? thanks
e**f
发帖数: 1
37
I received a copy of SQL server 7 backup file, but I only have SQL server 2000
and SQL server 6.5.
Where can I download SQL server 7 (trial) software?
Thanx.
a***a
发帖数: 2
38
来自主题: Database版 - MS SQL Server copy database wizard
Hi,
I have an emergent question about MS sql server copy database wizard.
If you have any suggestion/comment, please let me know. I am waiting...
My situation is:
two sql server 2000 in VPN and I have sysadmin in both db servers.
I am trying to copy one database from one server to another server using copy
database wizard. Everything works fine until I click finish to begin copy, it
stuck there for a long time. It just kill me.
Is there any other method to do this?
Please help me.
auhua
b*e
发帖数: 3845
39
来自主题: Database版 - 请教一个术语:server administration
it depends on the context of the question.
A server can be database server, windows 2003 server, linux server, web
server .....
M*****r
发帖数: 1536
40
来自主题: Database版 - SQL SERVER 2K5 schema vs. Oracle schema
In SQL Server 2K5, schema is introduced.
Any comparison to Oracle's schema?
SQL Server 2K5:
Server
Database
Schema
Login -- User account
Oracle:
Server
Database
Schema -- User account
What's the benefit of adding the schema layer? Why it is not designed like
Oracle's? (I may have some mis-understanding for the concept)
Also, in SQL Server, login and user account are different? What the benefit?
t***u
发帖数: 284
41
别的coworker 建了一个linker server 在SQL server 2005 上, 可是每次我去在sql
server client 上去access, 系统都说我是annoymous login, 不能access. 我是用
windows authentication 去connect Sql server database 的,难道是因为建 linked
server 的co worker 不是admin?
p********l
发帖数: 279
42
Cumulative Update 1 for SQL Server 2008 Service Pack 1 (SP1) contains only
hotfixes that were released in Cumulative Update 4 for SQL Server 2008.
These hotfixes are not included in SQL Server 2008 Service Pack 1.
Cumulative Update 1 for SQL 2008 SP1 is only intended as a post-service pack
rollup for Cumulative Update 4 for the release version of SQL Server 2008
customers who plan to upgrade to SQL Server 2008 SP1 and still keep the
hotfixes from Cumulative Update 4 for the release version of SQ
B*********L
发帖数: 700
43
下面是error log,不知道该怎么办:
2010-02-09 01:50:23.21 Server Error: 17311, Severity: 16, State: 1.
2010-02-09 01:50:23.21 Server SQL Server is terminating because of
fatal exception c0000005. This error may be caused by an unhandled Win32 or
C++ exception, or by an access violation encountered during exception
handling. Check the SQL error log for any related stack dumps or messages.
This exception forces SQL Server to shutdown. To recover from this error,
restart the server (unless SQLAgent is
v*****r
发帖数: 1119
44
写的不错,补充一下:
Isolation level 是ANSI SQL 的标准,不是SQL Server 的概念。每个 rdbms 实现
Isolation level 的方式都不一样,这也是 Oracle 比 SQL Server 设计上更优异的
一个地方。举个简单的例子,Oracle 的 Undo image的概念保证了 non-blocking read
没有 dirty read 的忧虑,所以根本不需要象 SQL Sever 那样为了提高 performance
牺牲 integrity。换句话说,同样的 transaction isolation level 下 (by default
都是 Read Committed), Oracle 不需要 SQL Server 那么多 Locking,所以 Oracle
在 performance 上比 SQL Server 有先天的优势。
前几天被老板逼着去 Redmond 上了MS SQLServer 两周课,认真做了 one on one 的比
较,不可否认,SQL Server 也有些相对的优点,不过在很多地方和 Oracl
m******y
发帖数: 588
45
我们其中一个production database server 的SAN 不够用了,又买了个新的,要把上
面大概600 GB的sql server databases移到新的SAN上,. 这个production db server
是一个active/passive cluster, 因为要minimal downtime,所以不能停了sql server
copy,现在想了两个方案,但是还都没试过,想问问这里有人干过这个吗?有什么好
建议。
z***y
发帖数: 7151
46
你说的情况有代表性。
我给一个Financial 客户做了一个近似的方案几年前。
先做一个全局备份, 然后需要另外一台和这台差不多性能的, 连在SAN上。 把备份
restore 在新
的san上。
两台做transactional replication.
最后在旧的server 上做最后的tail backup, 然后把新的server做为新的prod。
600GB, 差不多200分钟备份, 200分钟restore, 然后看Xsac 多少, 差不多再来50分
钟SYNC,
这中间没有downtime.
mirroring 也可以。

server
server
g***l
发帖数: 18555
47
来自主题: Database版 - local database to server
他说的什么LOCAL DATABASE传到WEB SERVER,本身就有问题,WEB SERVER后面要有
DATABASE SERVER来支持,什么叫好多LOCAL DATABASE传到WEB SERVER上去,DATABASE
SERVER呢,LOCAL DATABASE是干嘛的,有什么APP在用啊,这些都要考虑清楚。很多公
司图省事,不请SOLUTION ARCHITECT,自己穷糊弄,做出来的系统当然问题百出了。
l******t
发帖数: 660
48
SQL Server入门系列
1. introduction to sql server DBA
By Steve Yu, 07/17号周二9点, EST
http://www.anymeeting.com/CINASSUG1&rslt=77a3bf40-d488-4eaf-8f7
2. Introduction to Sql Server developer
07/25 周二9点, EST
3. Introduction to Sql Server BI developer
TBD
SQL Server技术交流系列
1. Data Warehouse modeling and lifecycle, data vault, kimball and Inmon
TBD
x*****g
发帖数: 764
49
Below is what I got from running a query to create Database Auti
Specification:
"Msg 33075, Level 16, State 3, Line 3
Granular auditing is not available in this edition of SQL Server. For more
information about feature support in the editions of SQL Server, see SQL
Server Books Online."
This simply means there is no way to do it in SQL Server Express

log.
w********i
发帖数: 244
50
How to restore the big .bak(75G)file from one server to another server in
sql server 2008?
Thank you!
首页 上页 1 2 3 4 5 6 7 8 9 10 下页 末页 (共10页)