Go to DotNetFunda.com
 Online : 692 |  Welcome, Guest!   Login
 
Home > Forums > Sql Server > how to change installation path sql server 2005 give steps setps ...

Sql Server Forum



how to change installation path sql server 2005 give steps setps

Author: Sagarp | Posted on: 11/6/2009 | Category: Sql Server | Views: 476 | Level: Bronze | Status: [Member]

HI


"I have install sql server 2005 but my default path not in up memory than error ocuure then i m try to chnage installation path sql 2005 setps but it's not chage it give automatically default.reply me with steps

thanks
sagarp
http://www.emanonsolutions.net

Thanks
SagarP
http://www.emanonsolutions.net
http://emanonsolutions.blogspot.com/


Reply

Found interesting? Add this to:

| More

 Responses

Vuyiswamb  
Posted on: 11/9/2009 5:42:58 AM
Level: NotApplicable | Status: [Member] [Administrator] | Reply

I really dont understand what you just wrote

Sagarp, please login to Mark As Answer, if this helps | Alert Moderator 

Dbdon  
Posted on: 11/12/2009 8:44:22 PM
Level: Starter | Status: [Member] | Reply

do you mean to ask that you have installed SQL 2005 on you server and it took default installation path but due to memory shortage you want to change the installation location on your disk?

Sagarp, please login to Mark As Answer, if this helps | Alert Moderator 

Sagarp  
Posted on: 11/12/2009 9:33:12 PM
Level: Bronze | Status: [Member] | Reply

yes sir,
"do you mean to ask that you have installed SQL 2005 on you server and it took default installation path but due to memory shortage you want to change the installation location on your disk?" this my problem


Thanks
SagarP
http://www.emanonsolutions.net
http://emanonsolutions.blogspot.com/

Sagarp, please login to Mark As Answer, if this helps | Alert Moderator 

Dbdon  
Posted on: 11/14/2009 10:11:56 AM
Level: Starter | Status: [Member] | Reply

while you install the sql server, it gives you an option to change the installation location, else it takes the default path in C: drive.
If you need your sql to be taken to some other drive, you need to install it again on your custom path and need to recreate the databases on the new installation. you can either take the backup of all the DB's and restore them on the new location or else you can just detach the files and attach them to the new server instance.



Sagarp, please login to Mark As Answer, if this helps | Alert Moderator 

Latest Posts

More ... 

 Write New Post


Advertisement

About Us | The Team | Advertise | Contact Us | Testimonials | Privacy Policy | Terms of Use | Link Exchange | Members | Go Top
General Notice: If you found plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.
Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 9/3/2010 3:59:52 AM