Welcome to SqlServer-QA.net
Sign in
|
Join
|
Help
Search
High Availability (SSQA.net)
Importance of Service Delivery within your environment, know more here.
Home
Email
About
RSS 2.0
Atom 1.0
Recent Posts
SQLPASS Summit 2008 - Effective Usage of Database Mirroring SQL 2005 & 2008
Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy - Tech-ed Online Panel
Tech-ed Online Panel: Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy
SQL Server 2005 Database Mirroring choosing optimum value for auto-failover timeout?
SQL Server - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover
Tags
2000
2005
2008
backup
best practices
business
cluster
database mirroring
databases
disaster
Disaster Recovery
error log
failover
firewall
high availability
log shipping
network
recovery
security
server
service account
sql server
tech-ed
News
<
August 2007
>
Su
Mo
Tu
We
Th
Fr
Sa
29
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
1
2
3
4
5
6
7
8
Navigation
Home
Blogs
Forums
My Reader
Business Continuity
Business Continuity
Archives
November 2008 (1)
September 2008 (1)
May 2008 (3)
March 2008 (1)
November 2007 (1)
October 2007 (2)
September 2007 (5)
August 2007 (3)
June 2007 (3)
May 2007 (2)
April 2007 (5)
March 2007 (3)
Renaming SQL Server that hosts Reporting Server
Sometimes business demands or change in naming convention for servers lead to situation where one should change / rename the Server running MS SQL Server, it would not that panic renaming SQL Server as you have sp_dropserver and sp_addserver to help you, but what if this SQL Server box have reporting server too; well microsoft has workaround for it; refer -
http://technet.microsoft.com/en-us/library/ms345235.aspx
Posted:
Wednesday, August 22, 2007 11:28 PM by
Hemantgiri S. Goswami
Filed under:
high availability
,
sql server
,
renaming server
,
reporting server
Comments
No Comments
Anonymous comments are disabled