Re: Rebuild of SQL Server

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 11:14:27 +0530

Hi,

Yes, You can do that and it will be the faster and easy methodology. But
ensure that you have the same service pack in new server as well.

Thanks
Hari
MCDBA

Thanks
Hari
MCDBA

"Greg H" <anonymous@discussions.microsoft.com> wrote in message
news:F5F90AF5-EA63-4192-BEB5-E4238C2A624F@microsoft.com...
> With the initial system DISK configuration now running out of space, it
will be necessary to reconfigure the disk structure - with a reload of Win2k
and SQL 2000.
> Question: Prior to the server rebuild, if SQL is stopped and system/user
database device files are copied to tape, after the rebuild of the server
(same name) and a reload of SQL 2000 to same drive, would it possible to
stop SQL and copy the same database device files from tape to avoid a SQL
restore of the databases. This would save some time and effort in recreating
the databases from scratch, including the master database.
>
> Thanks in Advance for any advice.

Relevant Pages

  • Re: Back-up Tape Drive
    ... > There will be things that require backup on both systems, ... > have more data on the sql box so placing the tape there would seem to make ... >> We are going to purchase two new servers running SQL 2000 Enterprise ... >> drive on either server. ...
    (microsoft.public.sqlserver.server)
  • Re: Back-up Tape Drive
    ... Can you not put a tape drive in both? ... There will be things that require backup on both systems, ... > We are going to purchase two new servers running SQL 2000 Enterprise ... > drive on either server. ...
    (microsoft.public.sqlserver.server)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)