moving sql to a new server

I just got a new server as the old server is too slow. What is the easiest
way to export the following to the new server:
1. Linked server configurations
2. Replication configuration
I read the Microsoft document called "HOW TO: Move Databases Between
Computers That Are Running SQL Server" but it does not discuss replication
information and linked servers. Right now the server is a publisher and I
have another box for the distributor and multiple boxes for subscribers. I'de
like to do the least amount of change on the replication and hope that there
is a way to restore the publisher databases on the new server (which has a
different name) and still have replication working.
Thanks"How to move SQL Server from one computer/server/machine to another"
http://vyaskn.tripod.com/moving_sql_server.htm
"Script out all linked/remote servers"
http://www.sqlservercentral.com/scripts/contributions/620.asp
Cristian Lefter, SQL Server MVP
"Anonymous" <Anonymous@.discussions.microsoft.com> wrote in message
news:979C3DDD-A9C9-486C-BAA3-5E00C94A3A1E@.microsoft.com...
>I just got a new server as the old server is too slow. What is the easiest
> way to export the following to the new server:
> 1. Linked server configurations
> 2. Replication configuration
> I read the Microsoft document called "HOW TO: Move Databases Between
> Computers That Are Running SQL Server" but it does not discuss replication
> information and linked servers. Right now the server is a publisher and I
> have another box for the distributor and multiple boxes for subscribers.
> I'de
> like to do the least amount of change on the replication and hope that
> there
> is a way to restore the publisher databases on the new server (which has a
> different name) and still have replication working.
> Thanks

moving sql to a new server

I just got a new server as the old server is too slow. What is the easiest
way to export the following to the new server:
1. Linked server configurations
2. Replication configuration
I read the Microsoft document called "HOW TO: Move Databases Between
Computers That Are Running SQL Server" but it does not discuss replication
information and linked servers. Right now the server is a publisher and I
have another box for the distributor and multiple boxes for subscribers. I'de
like to do the least amount of change on the replication and hope that there
is a way to restore the publisher databases on the new server (which has a
different name) and still have replication working.
Thanks
"How to move SQL Server from one computer/server/machine to another"
http://vyaskn.tripod.com/moving_sql_server.htm
"Script out all linked/remote servers"
http://www.sqlservercentral.com/scri...utions/620.asp
Cristian Lefter, SQL Server MVP
"Anonymous" <Anonymous@.discussions.microsoft.com> wrote in message
news:979C3DDD-A9C9-486C-BAA3-5E00C94A3A1E@.microsoft.com...
>I just got a new server as the old server is too slow. What is the easiest
> way to export the following to the new server:
> 1. Linked server configurations
> 2. Replication configuration
> I read the Microsoft document called "HOW TO: Move Databases Between
> Computers That Are Running SQL Server" but it does not discuss replication
> information and linked servers. Right now the server is a publisher and I
> have another box for the distributor and multiple boxes for subscribers.
> I'de
> like to do the least amount of change on the replication and hope that
> there
> is a way to restore the publisher databases on the new server (which has a
> different name) and still have replication working.
> Thanks
sql

moving sql to a new server

I just got a new server as the old server is too slow. What is the easiest
way to export the following to the new server:
1. Linked server configurations
2. Replication configuration
I read the Microsoft document called "HOW TO: Move Databases Between
Computers That Are Running SQL Server" but it does not discuss replication
information and linked servers. Right now the server is a publisher and I
have another box for the distributor and multiple boxes for subscribers. I'd
e
like to do the least amount of change on the replication and hope that there
is a way to restore the publisher databases on the new server (which has a
different name) and still have replication working.
Thanks"How to move SQL Server from one computer/server/machine to another"
http://vyaskn.tripod.com/moving_sql_server.htm
"Script out all linked/remote servers"
http://www.sqlservercentral.com/scr...butions/620.asp
Cristian Lefter, SQL Server MVP
"Anonymous" <Anonymous@.discussions.microsoft.com> wrote in message
news:979C3DDD-A9C9-486C-BAA3-5E00C94A3A1E@.microsoft.com...
>I just got a new server as the old server is too slow. What is the easiest
> way to export the following to the new server:
> 1. Linked server configurations
> 2. Replication configuration
> I read the Microsoft document called "HOW TO: Move Databases Between
> Computers That Are Running SQL Server" but it does not discuss replication
> information and linked servers. Right now the server is a publisher and I
> have another box for the distributor and multiple boxes for subscribers.
> I'de
> like to do the least amount of change on the replication and hope that
> there
> is a way to restore the publisher databases on the new server (which has a
> different name) and still have replication working.
> Thanks

Moving SQL from old server to new server

I need to move all our security information from our old server to a new
server. What is the best way to do this?
We are using SQL2000 SP2
Have a look at this list compiled by Andrew Kelly:
Moving DB's between Servers
http://www.support.microsoft.com/?id=314546
Moving SQL Server Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=224071
Using WITH MOVE in a Restore
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map logins to users
http://www.dbmaint.com/SyncSql Logins.asp
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
Restoring a .mdf
http://www.sqlservercentral.com/scri...p?scriptid=599
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<Patricia> wrote in message news:eng25okMGHA.2916@.tk2msftngp13.phx.gbl...
>I need to move all our security information from our old server to a new
> server. What is the best way to do this?
> We are using SQL2000 SP2
>

Moving SQL from old server to new server

I need to move all our security information from our old server to a new
server. What is the best way to do this?
We are using SQL2000 SP2Have a look at this list compiled by Andrew Kelly:
Moving DB's between Servers
http://www.support.microsoft.com/?id=314546
Moving SQL Server Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=224071
Using WITH MOVE in a Restore
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map logins to users
http://www.dbmaint.com/SyncSql Logins.asp
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
Restoring a .mdf
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<Patricia> wrote in message news:eng25okMGHA.2916@.tk2msftngp13.phx.gbl...
>I need to move all our security information from our old server to a new
> server. What is the best way to do this?
> We are using SQL2000 SP2
>

Moving SQL from old server to new server

I need to move all our security information from our old server to a new
server. What is the best way to do this?
We are using SQL2000 SP2Have a look at this list compiled by Andrew Kelly:
Moving DB's between Servers
http://www.support.microsoft.com/?id=314546
Moving SQL Server Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=224071
Using WITH MOVE in a Restore
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map logins to users
http://www.dbmaint.com/SyncSql Logins.asp
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
How to Resolve Permission Issues When a Database Is Moved Between SQL
Servers
http://www.support.microsoft.com/?id=240872
Restoring a .mdf
http://www.sqlservercentral.com/scr...sp?scriptid=599
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<Patricia> wrote in message news:eng25okMGHA.2916@.tk2msftngp13.phx.gbl...
>I need to move all our security information from our old server to a new
> server. What is the best way to do this?
> We are using SQL2000 SP2
>

Moving SQL DBs from machine to another with the same name

hello everyone. i am new to the group so i aplogize if this question has
been answered recently...

our sql db machine is too old. we bought a new server with which to replace
it. the trick is, we want to keep the name of the machine and db instance
the same.

obviously, we don't plan on having two machine with the same name on the
network at the same time. how do we handle this?

my first thought is to name the new machine with a new name (mach2),
transfer over all the db's, take the old one (mach1) off of the network.
rename the machine/instance to the old one (mach1).

if i do this, can i drop the original instance on the new machine
(mach2)-->register the new (mach1)? will my data be there?

Thanks so much for any relplies!!!Go Browns! (go@.browns.com) writes:
> hello everyone. i am new to the group so i aplogize if this question has
> been answered recently...
> our sql db machine is too old. we bought a new server with which to
> replace it. the trick is, we want to keep the name of the machine and
> db instance the same.
> obviously, we don't plan on having two machine with the same name on the
> network at the same time. how do we handle this?
> my first thought is to name the new machine with a new name (mach2),
> transfer over all the db's, take the old one (mach1) off of the network.
> rename the machine/instance to the old one (mach1).
> if i do this, can i drop the original instance on the new machine
> (mach2)-->register the new (mach1)? will my data be there?

This KB article gives some good advice
http://support.microsoft.com/defaul...1&Product=sql2k

You have have to use sp_dropserver and sp_addserver to get the name
of the server to be correct. Check SELECT @.@.servername, to see that it
has the right name.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||i will give this a shot tomorrow.

i really appreciate your feedback!

"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns94175A62E6CCYazorman@.127.0.0.1...
> Go Browns! (go@.browns.com) writes:
> > hello everyone. i am new to the group so i aplogize if this question
has
> > been answered recently...
> > our sql db machine is too old. we bought a new server with which to
> > replace it. the trick is, we want to keep the name of the machine and
> > db instance the same.
> > obviously, we don't plan on having two machine with the same name on the
> > network at the same time. how do we handle this?
> > my first thought is to name the new machine with a new name (mach2),
> > transfer over all the db's, take the old one (mach1) off of the network.
> > rename the machine/instance to the old one (mach1).
> > if i do this, can i drop the original instance on the new machine
> > (mach2)-->register the new (mach1)? will my data be there?
> This KB article gives some good advice
http://support.microsoft.com/defaul...1&Product=sql2k
> You have have to use sp_dropserver and sp_addserver to get the name
> of the server to be correct. Check SELECT @.@.servername, to see that it
> has the right name.
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp

Moving SQl cluster to new SAN...

We have two Microsoft Windows 2000/SQL 2000 clusters that need to move from
one SAN to another. The old SAN is going away.
Does anyone know of a procedures or white papers on how to accomplish this.
Dave
Read this excellent blog post -
http://msmvps.com/blogs/clusterhelp/archive/2005/08/05/61741.aspx
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:BDD48A84-20BD-4A29-87DF-94889805A3BB@.microsoft.com...
> We have two Microsoft Windows 2000/SQL 2000 clusters that need to move
> from
> one SAN to another. The old SAN is going away.
> Does anyone know of a procedures or white papers on how to accomplish
> this.
> --
> Dave

Moving SQL 2000 to different Drive

Hello All,
Please help. I have installed my SQL on an old powervault and needed to move
it to a new CX300. The mdf files are installed on F:\Microsoft SQL
Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
drive. I stopped all SQL services and copied data to new H and I drives, then
shutdown F and G drives. I renamed H and I to F and G and reboot. My problem
is that after the sever rebooted the SQL services won't start. I got an
error: the system cannot find the path specified. Any idea?
Thanks.
Put everything back to where you had it. Then read about sp_detach/
sp_attach in BOL.
"David" <David@.discussions.microsoft.com> wrote in message
news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> Hello All,
> Please help. I have installed my SQL on an old powervault and needed to
move
> it to a new CX300. The mdf files are installed on F:\Microsoft SQL
> Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
> drive. I stopped all SQL services and copied data to new H and I drives,
then
> shutdown F and G drives. I renamed H and I to F and G and reboot. My
problem
> is that after the sever rebooted the SQL services won't start. I got an
> error: the system cannot find the path specified. Any idea?
> Thanks.
|||Hi David,
(1) Use sp_detach_db
(2) Copy .mdf and .ldf files to the new drive
(3) Use sp_attach_db by specifying the new location
Thanks
GYK
|||Thanks for Reply,
Do I have to deal with any SQL installation files on the old F and G drives?
For example the bin folder also installed on F drive.
Thanks.
"ChrisR" wrote:

> Put everything back to where you had it. Then read about sp_detach/
> sp_attach in BOL.
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> move
> then
> problem
>
>
|||Chris,
Where did you install SQL Server? If on the old drives, you'll need to
reinstall it on the new drives.
Ron
Ron Talmage
SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:B89C0CF2-C9DA-4EEB-9D68-DBCBDA49A6FD@.microsoft.com...
> Thanks for Reply,
> Do I have to deal with any SQL installation files on the old F and G
drives?[vbcol=seagreen]
> For example the bin folder also installed on F drive.
> Thanks.
> "ChrisR" wrote:
to[vbcol=seagreen]
Server\MSSQL\Data[vbcol=seagreen]
drives,[vbcol=seagreen]
an[vbcol=seagreen]

Moving SQL 2000 to different Drive

Hello All,
Please help. I have installed my SQL on an old powervault and needed to move
it to a new CX300. The mdf files are installed on F:\Microsoft SQL
Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
drive. I stopped all SQL services and copied data to new H and I drives, then
shutdown F and G drives. I renamed H and I to F and G and reboot. My problem
is that after the sever rebooted the SQL services won't start. I got an
error: the system cannot find the path specified. Any idea?
Thanks.Put everything back to where you had it. Then read about sp_detach/
sp_attach in BOL.
"David" <David@.discussions.microsoft.com> wrote in message
news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> Hello All,
> Please help. I have installed my SQL on an old powervault and needed to
move
> it to a new CX300. The mdf files are installed on F:\Microsoft SQL
> Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
> drive. I stopped all SQL services and copied data to new H and I drives,
then
> shutdown F and G drives. I renamed H and I to F and G and reboot. My
problem
> is that after the sever rebooted the SQL services won't start. I got an
> error: the system cannot find the path specified. Any idea?
> Thanks.|||Hi David,
(1) Use sp_detach_db
(2) Copy .mdf and .ldf files to the new drive
(3) Use sp_attach_db by specifying the new location
--
Thanks
GYK|||Thanks for Reply,
Do I have to deal with any SQL installation files on the old F and G drives?
For example the bin folder also installed on F drive.
Thanks.
"ChrisR" wrote:
> Put everything back to where you had it. Then read about sp_detach/
> sp_attach in BOL.
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> > Hello All,
> >
> > Please help. I have installed my SQL on an old powervault and needed to
> move
> > it to a new CX300. The mdf files are installed on F:\Microsoft SQL
> > Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
> > drive. I stopped all SQL services and copied data to new H and I drives,
> then
> > shutdown F and G drives. I renamed H and I to F and G and reboot. My
> problem
> > is that after the sever rebooted the SQL services won't start. I got an
> > error: the system cannot find the path specified. Any idea?
> >
> > Thanks.
>
>|||Chris,
Where did you install SQL Server? If on the old drives, you'll need to
reinstall it on the new drives.
Ron
--
Ron Talmage
SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:B89C0CF2-C9DA-4EEB-9D68-DBCBDA49A6FD@.microsoft.com...
> Thanks for Reply,
> Do I have to deal with any SQL installation files on the old F and G
drives?
> For example the bin folder also installed on F drive.
> Thanks.
> "ChrisR" wrote:
> > Put everything back to where you had it. Then read about sp_detach/
> > sp_attach in BOL.
> >
> >
> > "David" <David@.discussions.microsoft.com> wrote in message
> > news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> > > Hello All,
> > >
> > > Please help. I have installed my SQL on an old powervault and needed
to
> > move
> > > it to a new CX300. The mdf files are installed on F:\Microsoft SQL
> > > Server\MSSQL\Data and the ldf files on G:\Microsoft SQL
Server\MSSQL\Data
> > > drive. I stopped all SQL services and copied data to new H and I
drives,
> > then
> > > shutdown F and G drives. I renamed H and I to F and G and reboot. My
> > problem
> > > is that after the sever rebooted the SQL services won't start. I got
an
> > > error: the system cannot find the path specified. Any idea?
> > >
> > > Thanks.
> >
> >
> >

Moving SQL 2000 to different Drive

Hello All,
Please help. I have installed my SQL on an old powervault and needed to move
it to a new CX300. The mdf files are installed on F:\Microsoft SQL
Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
drive. I stopped all SQL services and copied data to new H and I drives, the
n
shutdown F and G drives. I renamed H and I to F and G and reboot. My problem
is that after the sever rebooted the SQL services won't start. I got an
error: the system cannot find the path specified. Any idea?
Thanks.Put everything back to where you had it. Then read about sp_detach/
sp_attach in BOL.
"David" <David@.discussions.microsoft.com> wrote in message
news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> Hello All,
> Please help. I have installed my SQL on an old powervault and needed to
move
> it to a new CX300. The mdf files are installed on F:\Microsoft SQL
> Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
> drive. I stopped all SQL services and copied data to new H and I drives,
then
> shutdown F and G drives. I renamed H and I to F and G and reboot. My
problem
> is that after the sever rebooted the SQL services won't start. I got an
> error: the system cannot find the path specified. Any idea?
> Thanks.|||Hi David,
(1) Use sp_detach_db
(2) Copy .mdf and .ldf files to the new drive
(3) Use sp_attach_db by specifying the new location
Thanks
GYK|||Thanks for Reply,
Do I have to deal with any SQL installation files on the old F and G drives?
For example the bin folder also installed on F drive.
Thanks.
"ChrisR" wrote:

> Put everything back to where you had it. Then read about sp_detach/
> sp_attach in BOL.
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> move
> then
> problem
>
>|||Chris,
Where did you install SQL Server? If on the old drives, you'll need to
reinstall it on the new drives.
Ron
--
Ron Talmage
SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:B89C0CF2-C9DA-4EEB-9D68-DBCBDA49A6FD@.microsoft.com...
> Thanks for Reply,
> Do I have to deal with any SQL installation files on the old F and G
drives?[vbcol=seagreen]
> For example the bin folder also installed on F drive.
> Thanks.
> "ChrisR" wrote:
>
to[vbcol=seagreen]
Server\MSSQL\Data[vbcol=seagreen]
drives,[vbcol=seagreen]
an[vbcol=seagreen]

Moving RS 2005 Reports to new server

Hi Guru,

Currently, we are running our RS 2005 reports on our old hardware and wanted to move them to better server where I’ll be building it tomorrow. On the existing server, we installed both database and reporting services running on the same box but I’m ONLY planning to install reporting service on the new server.

What are the options to move RDL, shared data sources, shared schedules, jobs to the new server? I heard people talked about backing up and restore both ReportServer and ReportServerTempdb databases to the new server would do it. How can I restore or attach these two dbs to new server when we don’t plan to install database services on it?

Please help!

Thanks,

Silaphet,

You probably have to deploy your reports again using Visual Studio.|||YOu can do a backup and restore on the new server of the Report Server database. You will additionally have to backup the encryption key from the old server using the configuration utility and apply / restore it on the new one as the content of the database is encrypted and cannot be decrypted without the key of the old server.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Moving RS 2005 Reports to new server

Hi Guru,
Currently, we are running our RS 2005 reports on our old hardware and
wanted to move them to better server where I'll be building it
tomorrow. On the existing server, we installed both database and
reporting services running on the same box but I'm ONLY planning to
install reporting service on the new server.
What are the options to move RDL, shared data sources, shared
schedules, jobs to the new server? I heard people talked about backing
up and restore both ReportServer and ReportServerTempdb databases to
the new server would do it. How can I restore or attach these two dbs
to new server when we don't plan to install database services on it?
Please help!
Thanks,
Silaphet,If you are moving only RS and plan on the databases used by RS for its
metadata/object caching to stay where it is then you definitely are not
going to want to touch the databases. When you mention the RDL, shared
datasource, etc etc. These are all in the database. There are no files. You
only need the application to be moved and then pointed to the database. RDL
only exists on the development. When you deploy they are compiled and stored
in the database.
If you have enterprise then you should just treat this like a web farm and
install the new one and have both using the same databases and then remove
the old one once done. Otherwise you need to remove the old one and then
install the new. When you install the new you point it to the databases.
Standard edition does not support web farm (multiple RS all using the same
databases), only enterprise.
Here is a link that deals with totally moving RS (the app and the supporting
databases) which might help you understand the pieces but isn't quite what
you are doing:
http://support.microsoft.com/default.aspx?scid=842425
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<smounkhaty@.bremer.com> wrote in message
news:1165856070.452398.223800@.73g2000cwn.googlegroups.com...
> Hi Guru,
> Currently, we are running our RS 2005 reports on our old hardware and
> wanted to move them to better server where I'll be building it
> tomorrow. On the existing server, we installed both database and
> reporting services running on the same box but I'm ONLY planning to
> install reporting service on the new server.
> What are the options to move RDL, shared data sources, shared
> schedules, jobs to the new server? I heard people talked about backing
> up and restore both ReportServer and ReportServerTempdb databases to
> the new server would do it. How can I restore or attach these two dbs
> to new server when we don't plan to install database services on it?
> Please help!
> Thanks,
> Silaphet,
>

Moving physical disks with database inside?

Hi,
I have an old Datawarehouse server with 8 disks
in these disks I have a Raid 5 setup for my datawarehouse based on 4 disks.
I want to move these 4 drives to a new server (better processors).
My 2 servers are Dell based with Win 2003 ent. edition + SQL server 2000
ent. edition.
Can I do the move?
What I have to double check before?
Thanks.
Jerome.
Hello Jerome,
Each manufacturer has his own way of writing into the RAID drives, ie, IBM
servers RAID5 drives cannot be moved
into a HP server ... etc. Infact, the manufacturer himself might comeout
with newer and efficient ways of writing into the
diskdrives (Happened to us once with the HP servers). Lot depends on the
RAID controller cards that you r using in
the two servers.
Check with the vendor of the servers andf find out if the Old RAID drives
are upward compatible with the new machine with
the New controlller cards.
From my experience once when the Hardware recognises these drives, OS shud
have no problem in recognizing them
as well
Gopi
"Jj" <willgart_A_@.hotmail_A_.com> wrote in message
news:Ow16FLoJFHA.576@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have an old Datawarehouse server with 8 disks
> in these disks I have a Raid 5 setup for my datawarehouse based on 4
> disks.
> I want to move these 4 drives to a new server (better processors).
> My 2 servers are Dell based with Win 2003 ent. edition + SQL server 2000
> ent. edition.
> Can I do the move?
> What I have to double check before?
> Thanks.
> Jerome.
>
|||thanks for the info
I'll call the vendor.
"gopi" <rgopinath@.hotmail.com> wrote in message
news:eH4B9nyJFHA.3084@.TK2MSFTNGP10.phx.gbl...
> Hello Jerome,
> Each manufacturer has his own way of writing into the RAID drives, ie, IBM
> servers RAID5 drives cannot be moved
> into a HP server ... etc. Infact, the manufacturer himself might comeout
> with newer and efficient ways of writing into the
> diskdrives (Happened to us once with the HP servers). Lot depends on the
> RAID controller cards that you r using in
> the two servers.
> Check with the vendor of the servers andf find out if the Old RAID drives
> are upward compatible with the new machine with
> the New controlller cards.
> From my experience once when the Hardware recognises these drives, OS shud
> have no problem in recognizing them
> as well
>
> Gopi
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:Ow16FLoJFHA.576@.TK2MSFTNGP15.phx.gbl...
>

Moving physical disks with database inside?

Hi,
I have an old Datawarehouse server with 8 disks
in these disks I have a Raid 5 setup for my datawarehouse based on 4 disks.
I want to move these 4 drives to a new server (better processors).
My 2 servers are Dell based with Win 2003 ent. edition + SQL server 2000
ent. edition.
Can I do the move?
What I have to double check before?
Thanks.
Jerome.Hello Jerome,
Each manufacturer has his own way of writing into the RAID drives, ie, IBM
servers RAID5 drives cannot be moved
into a HP server ... etc. Infact, the manufacturer himself might comeout
with newer and efficient ways of writing into the
diskdrives (Happened to us once with the HP servers). Lot depends on the
RAID controller cards that you r using in
the two servers.
Check with the vendor of the servers andf find out if the Old RAID drives
are upward compatible with the new machine with
the New controlller cards.
From my experience once when the Hardware recognises these drives, OS shud
have no problem in recognizing them
as well
Gopi
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:Ow16FLoJFHA.576@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have an old Datawarehouse server with 8 disks
> in these disks I have a Raid 5 setup for my datawarehouse based on 4
> disks.
> I want to move these 4 drives to a new server (better processors).
> My 2 servers are Dell based with Win 2003 ent. edition + SQL server 2000
> ent. edition.
> Can I do the move?
> What I have to double check before?
> Thanks.
> Jerome.
>|||thanks for the info
I'll call the vendor.
"gopi" <rgopinath@.hotmail.com> wrote in message
news:eH4B9nyJFHA.3084@.TK2MSFTNGP10.phx.gbl...
> Hello Jerome,
> Each manufacturer has his own way of writing into the RAID drives, ie, IBM
> servers RAID5 drives cannot be moved
> into a HP server ... etc. Infact, the manufacturer himself might comeout
> with newer and efficient ways of writing into the
> diskdrives (Happened to us once with the HP servers). Lot depends on the
> RAID controller cards that you r using in
> the two servers.
> Check with the vendor of the servers andf find out if the Old RAID drives
> are upward compatible with the new machine with
> the New controlller cards.
> From my experience once when the Hardware recognises these drives, OS shud
> have no problem in recognizing them
> as well
>
> Gopi
> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> news:Ow16FLoJFHA.576@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> I have an old Datawarehouse server with 8 disks
>> in these disks I have a Raid 5 setup for my datawarehouse based on 4
>> disks.
>> I want to move these 4 drives to a new server (better processors).
>> My 2 servers are Dell based with Win 2003 ent. edition + SQL server 2000
>> ent. edition.
>> Can I do the move?
>> What I have to double check before?
>> Thanks.
>> Jerome.
>>
>

Moving physical disks with database inside?

Hi,
I have an old Datawarehouse server with 8 disks
in these disks I have a Raid 5 setup for my datawarehouse based on 4 disks.
I want to move these 4 drives to a new server (better processors).
My 2 servers are Dell based with Win 2003 ent. edition + SQL server 2000
ent. edition.
Can I do the move?
What I have to double check before?
Thanks.
Jerome.
Hello Jerome,
Each manufacturer has his own way of writing into the RAID drives, ie, IBM
servers RAID5 drives cannot be moved
into a HP server ... etc. Infact, the manufacturer himself might comeout
with newer and efficient ways of writing into the
diskdrives (Happened to us once with the HP servers). Lot depends on the
RAID controller cards that you r using in
the two servers.
Check with the vendor of the servers andf find out if the Old RAID drives
are upward compatible with the new machine with
the New controlller cards.
From my experience once when the Hardware recognises these drives, OS shud
have no problem in recognizing them
as well
Gopi
"Jj" <willgart_A_@.hotmail_A_.com> wrote in message
news:Ow16FLoJFHA.576@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have an old Datawarehouse server with 8 disks
> in these disks I have a Raid 5 setup for my datawarehouse based on 4
> disks.
> I want to move these 4 drives to a new server (better processors).
> My 2 servers are Dell based with Win 2003 ent. edition + SQL server 2000
> ent. edition.
> Can I do the move?
> What I have to double check before?
> Thanks.
> Jerome.
>
|||thanks for the info
I'll call the vendor.
"gopi" <rgopinath@.hotmail.com> wrote in message
news:eH4B9nyJFHA.3084@.TK2MSFTNGP10.phx.gbl...
> Hello Jerome,
> Each manufacturer has his own way of writing into the RAID drives, ie, IBM
> servers RAID5 drives cannot be moved
> into a HP server ... etc. Infact, the manufacturer himself might comeout
> with newer and efficient ways of writing into the
> diskdrives (Happened to us once with the HP servers). Lot depends on the
> RAID controller cards that you r using in
> the two servers.
> Check with the vendor of the servers andf find out if the Old RAID drives
> are upward compatible with the new machine with
> the New controlller cards.
> From my experience once when the Hardware recognises these drives, OS shud
> have no problem in recognizing them
> as well
>
> Gopi
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:Ow16FLoJFHA.576@.TK2MSFTNGP15.phx.gbl...
>

Moving physical disks with database inside?

Hi,
I have an old Datawarehouse server with 8 disks
in these disks I have a Raid 5 setup for my datawarehouse based on 4 disks.
I want to move these 4 drives to a new server (better processors).
My 2 servers are Dell based with Win 2003 ent. edition + SQL server 2000
ent. edition.
Can I do the move?
What I have to double check before?
Thanks.
Jerome.Hello Jerome,
Each manufacturer has his own way of writing into the RAID drives, ie, IBM
servers RAID5 drives cannot be moved
into a HP server ... etc. Infact, the manufacturer himself might comeout
with newer and efficient ways of writing into the
diskdrives (Happened to us once with the HP servers). Lot depends on the
RAID controller cards that you r using in
the two servers.
Check with the vendor of the servers andf find out if the Old RAID drives
are upward compatible with the new machine with
the New controlller cards.
From my experience once when the hardware recognises these drives, OS shud
have no problem in recognizing them
as well
Gopi
"Jj" <willgart_A_@.hotmail_A_.com> wrote in message
news:Ow16FLoJFHA.576@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have an old Datawarehouse server with 8 disks
> in these disks I have a Raid 5 setup for my datawarehouse based on 4
> disks.
> I want to move these 4 drives to a new server (better processors).
> My 2 servers are Dell based with Win 2003 ent. edition + SQL server 2000
> ent. edition.
> Can I do the move?
> What I have to double check before?
> Thanks.
> Jerome.
>|||thanks for the info
I'll call the vendor.
"gopi" <rgopinath@.hotmail.com> wrote in message
news:eH4B9nyJFHA.3084@.TK2MSFTNGP10.phx.gbl...
> Hello Jerome,
> Each manufacturer has his own way of writing into the RAID drives, ie, IBM
> servers RAID5 drives cannot be moved
> into a HP server ... etc. Infact, the manufacturer himself might comeout
> with newer and efficient ways of writing into the
> diskdrives (Happened to us once with the HP servers). Lot depends on the
> RAID controller cards that you r using in
> the two servers.
> Check with the vendor of the servers andf find out if the Old RAID drives
> are upward compatible with the new machine with
> the New controlller cards.
> From my experience once when the hardware recognises these drives, OS shud
> have no problem in recognizing them
> as well
>
> Gopi
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:Ow16FLoJFHA.576@.TK2MSFTNGP15.phx.gbl...
>

Moving my SQL 7.0 databases to a new server to replace the old server

My existing SQL server is an old box that can no longer cope with the load. I need to replace it with a brand new box.

I am looking for a comprehensive set of steps that I could follow to ensure that the transition to the new server goes well.

I'm looking to transfer all my user databases but I'm not so sure whether I have to backup and restore my system databases to the new server as well.

I want to name the new server the same as the old server since I will be taking the old server out of production but I'm not sure whether I should rename the server AFTER I move over all the database and how that would affect SQL. Or should I first rename the old server, remove it out of the domain, then name my new server with the same name as my old server, and then proceed with the SQL installation and the moving of the databases.

Also, I do have a maintenance plan, DTS packages and some jobs set up on my old server that I would also like to move to the new server.

Is there a web page that explains all the steps in granular detail ?

SQL Server 2005 Books Online actually has pretty good info on this. I just did a search on "upgrade 7.0" and it provided a good roadmap.

Paul

Moving my SQL 7.0 databases to a new server to replace the old server

My existing SQL server is an old box that can no longer cope with the load. I need to replace it with a brand new box.

I am looking for a comprehensive set of steps that I could follow to ensure that the transition to the new server goes well.

I'm looking to transfer all my user databases but I'm not so sure whether I have to backup and restore my system databases to the new server as well.

I want to name the new server the same as the old server since I will be taking the old server out of production but I'm not sure whether I should rename the server AFTER I move over all the database and how that would affect SQL. Or should I first rename the old server, remove it out of the domain, then name my new server with the same name as my old server, and then proceed with the SQL installation and the moving of the databases.

Also, I do have a maintenance plan, DTS packages and some jobs set up on my old server that I would also like to move to the new server.

Is there a web page that explains all the steps in granular detail ?

SQL Server 2005 Books Online actually has pretty good info on this. I just did a search on "upgrade 7.0" and it provided a good roadmap.

Paul

Moving Model and tempdb

Hi!
After i Upgraded my SQL 7 to SQL 2000 my model and tempdb
database is still in th old location(C:\MSSQL7\Data). How
can i Move it. I have traid all.
Best Regards!
/Jens Nilsson
Database Administrator
Malmo - SwedenHave you looked at this
http://support.microsoft.com/?kbid=224071
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Jens Nilsson" <sqlis.mas@.skane.se> wrote in message
news:069401c35cb0$37db6330$a601280a@.phx.gbl...
> Hi!
> After i Upgraded my SQL 7 to SQL 2000 my model and tempdb
> database is still in th old location(C:\MSSQL7\Data). How
> can i Move it. I have traid all.
> Best Regards!
> /Jens Nilsson
> Database Administrator
> Malmo - Sweden