how to change installation path sql server 2005 give steps setps

Posted by Sagarp under Sql Server on 11/6/2009 | Views : 6112 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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 | Reply with Attachment

Alert Moderator

Responses

Posted by: Vuyiswamb on: 11/9/2009 [Member] [MVP] [Administrator] NotApplicable

0	I really dont understand what you just wrote Thank you for posting at Dotnetfunda [Administrator] Sagarp, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Dbdon on: 11/12/2009 [Member] Starter

0	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, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sagarp on: 11/12/2009 [Member] Bronze

0	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, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Dbdon on: 11/14/2009 [Member] Starter

0	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, if this helps please login to Mark As Answer. \| Alert Moderator

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, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts