Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 3rd, 2007, 10:47 AM
Registered User
 
Join Date: Jan 2007
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Can you change root directory of sqlServer 2005

Hi there,

I need to change the root directory path of a SQL Server 2005 installation.

Is it possible to manually change the root directory after installation or do I need to re install it?

Thanks you for you help
H

 
Old April 3rd, 2007, 12:54 PM
Friend of Wrox
 
Join Date: May 2006
Posts: 246
Thanks: 0
Thanked 0 Times in 0 Posts
Default

First obvious question is

"WHY?"


 
Old April 4th, 2007, 03:26 AM
Registered User
 
Join Date: Jan 2007
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Would like to point the root directory to a larger disc partition

 
Old April 4th, 2007, 03:58 AM
Friend of Wrox
 
Join Date: May 2006
Posts: 246
Thanks: 0
Thanked 0 Times in 0 Posts
Default

SQL Server files only occupies about 1 GB of space.
You can put USER DATABASES on any partition you want, as far as SQL Server service concerns.

Is this what your problem really is? You are out of space for databases?


 
Old April 4th, 2007, 04:07 AM
Registered User
 
Join Date: Jan 2007
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have been asked at work if I could change the root directory to another partition in order to prevent us from running out of space in the future.
I was hoping i could change the root path without having to reinstall sql server.

Thanks for you help


 
Old April 4th, 2007, 05:46 AM
Registered User
 
Join Date: Jan 2007
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Got it sorted thanks.

Just detached the database copied files across to new directory and reattached database.

http://support.microsoft.com/kb/224071

Cheers






Similar Threads
Thread Thread Starter Forum Replies Last Post
SQLserver 2000 vs SQLserver 2005 Express cJeffreywang BOOK: Beginning ASP.NET 2.0 and Databases 0 April 22nd, 2007 09:52 AM
Moving the MySQL Database Root Directory miguelm BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 February 26th, 2005 02:13 PM
Root Directory Chudz BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 1 July 11th, 2004 03:13 PM
Get IIS root directory from VB.NET weichunglow VB.NET 2002/2003 Basics 2 June 16th, 2004 10:11 PM
PHP uploaded to root directory arnec BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 1 August 15th, 2003 03:24 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.