Re: SQL Server moving to larger drive
- From: scoots987 <scoots987@xxxxxxxxx>
- Date: Tue, 27 Nov 2007 18:07:33 -0800 (PST)
On Nov 27, 4:40 pm, Erland Sommarskog <esq...@xxxxxxxxxxxxx> wrote:
scoots987 (scoots...@xxxxxxxxx) writes:
I have a Windows 2003 server with SQL Server 2005 installed. The
server is on small drive and we would like to upgrade to much larger
harddrives. I've been hearing of problems using Ghost to get an image
and placing the image onto the new drive. I think this is more of a
Windows 2003 problem, but this server is for nothing but the SQL
Server databases. Does anyone have a clear method of moving this
server to the larger drives?
Why not just keep the SQL Server installation on the current drive,
and move only the databases to the new drives?
This KB article may be helpful:http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
--
Erland Sommarskog, SQL Server MVP, esq...@xxxxxxxxxxxxx
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Great and obvious solution that I didn't even think about. However,
the server has a RAID configuration and wonder how to do that? If the
databases are on a separate drive can this drive be RAID and the
operating system on non RAID? Or other configuration?
Thanks!
.
- Follow-Ups:
- Re: SQL Server moving to larger drive
- From: Erland Sommarskog
- Re: SQL Server moving to larger drive
- References:
- SQL Server moving to larger drive
- From: scoots987
- Re: SQL Server moving to larger drive
- From: Erland Sommarskog
- SQL Server moving to larger drive
- Prev by Date: Re: Not Exists joining 2 tables
- Next by Date: Re: many "or" operation make system choose incorrect index
- Previous by thread: Re: SQL Server moving to larger drive
- Next by thread: Re: SQL Server moving to larger drive
- Index(es):
Relevant Pages
|
