By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,111 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

SQL Server moving to larger drive

P: n/a
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?

TIA.
Nov 27 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
scoots987 (sc*******@gmail.com) 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...b;EN-US;224071

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Nov 27 '07 #2

P: n/a
On Nov 27, 4:40 pm, Erland Sommarskog <esq...@sommarskog.sewrote:
scoots987 (scoots...@gmail.com) 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...b;EN-US;224071

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

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!
Nov 28 '07 #3

P: n/a
scoots987 (sc*******@gmail.com) writes:
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?
Of course, you can have one drive in your system which is a RAID, and one
which is not. I would sort of expect that it is possible to add more
disk to a RAID as well, but maybe there has to be room for them in
the cabinet. (I'm really outside my field of expertise here.)

What RAID configuration do you use? The recommended for SQL Server is
RAID1+0.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Nov 28 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.